How to calculate max in DS

tanaya.deshpande@tieto.co · Thu Mar 17, 2011 4:43 am

I have 7 employees coming in a single stream whose salary is different on Monday ,Tuesday and Wednesday.
Now I want to calculate
1) total salary of each employee.for three days..... after that
2)the employee who has max salary

How can I impliment this in DS

GJ_Stage · Post by **GJ_Stage** » Thu Mar 17, 2011 4:45 am

Please use aggregator stage.

soumya5891 · Post by **soumya5891** » Thu Mar 17, 2011 10:56 am

1. First need a dummy col with any value say 1 you can do it in a transformer stage or col generator stage

2. Need a aggregator stage where you determine total salary of the employee

2. Now use a sort stage and sort the salary in descending order and then remove duplicate on the basis of dummy col

You will get the highest salary

tanaya.deshpande@tieto.co · Fri Mar 18, 2011 4:03 am

Thanks a lot :D

devesh_ssingh · Post by **devesh_ssingh** » Fri Mar 18, 2011 4:49 am

you can put resolve