Selecting Max(date) column with multiple rows

priyadarshikunal · Post by **priyadarshikunal** » Wed Aug 11, 2010 9:56 am

PhilHibbs wrote:
priyadarshikunal wrote:It can be found in sub property of 'Column for calculation'.
Nope, no "Preserve type" attribute...

Doesn't seem to be there, i think its 7.x screenshot. In which it might be buried somewhere or even not be there.

priyadarshikunal · Post by **priyadarshikunal** » Wed Aug 11, 2010 10:06 am

definately, its there in version 8.x, not quite sure about 7.x but if its not there (i think its not), one workaround can be converting it to julian date, before aggregator(or decimal as yyyymmdd/yyyymmddhh24miss ) to get the max and convert it back.

kumar_s · Post by **kumar_s** » Wed Aug 11, 2010 10:56 am

Do you need an Aggregator? Why not just Sort the Data based on Code and Date and use Remove Duplicate to retain First. (Or last, based on sorting order)

PhilHibbs · Post by **PhilHibbs** » Wed Aug 11, 2010 10:58 am

kumar_s wrote:Do you need an Aggregator? Why not just Sort the Data based on Code and Date and use Remove Duplicate to retain First. (Or last, based on sorting order)

I'm already aggregating the data on the key, then I found I needed the max date, so I just slipped it in.

chulett · Post by **chulett** » Wed Aug 11, 2010 11:55 am

priyadarshikunal wrote:definately, its there in version 8.x, not quite sure about 7.x but if its not there (i think its not), one workaround can be converting it to julian date, before aggregator(or decimal as yyyymmdd/yyyymmddhh24miss ) to get the max and convert it back.

It's there. Somewhere.