How can I get the minimum date in the aggregator?

ray.wurlod · Post by **ray.wurlod** » Sun Dec 20, 2009 4:21 pm

I don't know that there's a solution but, as a workaround, convert your date to a Julian date (int32 or int64, perhaps) and take the minimum of that.

igorbmartins · Post by **igorbmartins** » Sun Dec 20, 2009 5:21 pm

Really? It Is not have other way? I thought in use the function iconv, but I see that in the Parallel JOB it is not work. How can I convert this date to int?

Thanks.

chulett · Post by **chulett** » Sun Dec 20, 2009 6:32 pm

What about leaving it as a string (not a date) with the string in 'yyyy-mm-dd' format and then taking the minimum of that? That or an integer in 'yyyymmdd' format.

priyadarshikunal · Post by **priyadarshikunal** » Mon Dec 21, 2009 4:10 am

probably you can try to set the additional option 'Preserve Type' to true.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 21, 2009 1:53 pm

Preserve Type will work. I believe this is only available in version 8.1 and later.

samder76 · Post by **samder76** » Tue Dec 22, 2009 3:54 am

Instead of using an aggregator stage to find a minimun date, you can use a "Remove Duplicates" sorting your date data with the "ascending" option (when you specify your partitioning). Finally, you have just to retain the first row (duplicate to retain : first). It works well with date type for each version.

ajay.vaidyanathan · Post by **ajay.vaidyanathan** » Tue Dec 22, 2009 6:34 am

Hi,

Your DATA basically contains "DATE" values and your aggregator gets your output in "DOUBLE" data type. So convert your DATA column to a format compatible with DOUBLE data type and then try using Aggregator.

TonyInFrance · Post by **TonyInFrance** » Fri Mar 11, 2016 11:30 am

Old topic (I know) but I had to go through this (and other similar ones) since I was looking for a solution.

On a hunch I tried the option Preserve type = True within the Aggregator itself....worked fine...

No more warnings / aborts.

Basically what happens I guess is on choosing to preserve the datatype the output of the aggregator remains in iys source format.

chulett · Post by **chulett** » Fri Mar 11, 2016 11:48 am

You really decided to spread the love around, eh?

It has been mentioned a number of times over the years, I got 40+ hits when searching for "preserve type" just now. Up by four from yesterday.

TonyInFrance · Post by **TonyInFrance** » Sat Mar 12, 2016 4:20 am

Ha ha @ Craig

But before you and the Ray discipline me for the misdemeanor, in my defense I found 4 hits when I searched for the error message - No default type conversion from type "date" to type "dfloat".

Thought I'd thus update all 4 since in neither of them was the "preserve type" suggested as a possible solution...

chulett · Post by **chulett** » Sat Mar 12, 2016 7:41 am

Ha! There was no intent to discipline, I was just amused to keep finding your post as I worked my way through all the new posts that morning.