DSXchange

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.

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.

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)

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.

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.