maximum value of a group

ramesh_inform · Post by **ramesh_inform** » Sat Apr 19, 2008 8:01 am

Is there any way to find a maximum value of a group without using aggregator?

keshav0307 · Post by **keshav0307** » Sat Apr 19, 2008 9:40 am

yes, you can do it in transformer.

ray.wurlod · Post by **ray.wurlod** » Sat Apr 19, 2008 4:33 pm

If the data are sorted on the grouping keys then on the column for which you need the maximum value per group, you could also use a Remove Duplicates stage.

ramesh_inform · Post by **ramesh_inform** » Thu Apr 24, 2008 3:34 am

thanks ray

kumar:
can you please elaborate on this?how can we do that in transformer?

keshav0307 · Post by **keshav0307** » Thu Apr 24, 2008 7:16 am

search this forum for capturing duplicates using transformer.
if you have sorted the data in ascending order then keep the last value of the choosen keys.
you need to use stage variable to do it.

viewtopic.php?t=113852

ramesh_inform · Post by **ramesh_inform** » Fri Apr 25, 2008 12:11 am

thanks keshav

can you suggest any method using system variables in a transformer?

keshav0307 · Post by **keshav0307** » Fri Apr 25, 2008 1:02 am

read the online manual parallel job develpoers giude page 429 -...............