Get max datetime column doing a froup by
Posted: Tue Oct 06, 2009 11:48 pm
I have a job where I need to get the max(datetime_col) with a group by on group_by_col.
I used an aggregator where I gave the group by value as group_by_col and then the sort key as datetime_col.
The problem is that Aggregator only gives a double or a decimal output and not a datetime.
Thanks!
I used an aggregator where I gave the group by value as group_by_col and then the sort key as datetime_col.
The problem is that Aggregator only gives a double or a decimal output and not a datetime.
Thanks!