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
How to calculate max in DS
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 94
- Joined: Sun Jul 18, 2010 11:35 pm
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 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
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
Soumya
-
- Participant
- Posts: 94
- Joined: Sun Jul 18, 2010 11:35 pm