Group By and find maximum
Posted: Sat Sep 22, 2012 4:30 pm
Hi All,
I have a input with 3 columns col A, col B and col C
For each of col A and col B combination, I have to write max(col C) to the output.
There can be duplicate data in the columns col A, col B and col C
can someone please let me know how do i achieve this in datastage.
Thanks
pavan
I have a input with 3 columns col A, col B and col C
For each of col A and col B combination, I have to write max(col C) to the output.
There can be duplicate data in the columns col A, col B and col C
can someone please let me know how do i achieve this in datastage.
Thanks
pavan