DSXchange

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

Please use aggregator stage.

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

Thanks a lot :D

you can put resolve