HOW TO FIND OUT MAX SALARY USING TRASFORMER STAGE
HELP ME
THANKS IN ADVANCE
HOW TO FIND OUT MAX SALARY USING TRASFORMER STAGE
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 12
- Joined: Tue Aug 26, 2008 10:48 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
Please do not shout. (All capitals = shouting.)
Why do you specifically want to use a Transformer stage? It is more usual to use an Aggregator stage to find a maximum (or perhaps an SQL query).
It can, of course, be achieved, using the fact that stage variables are evaluated in the order in which they appear in the grid, so that a value from the previous row can be remembered. Therefore you only need to compare the current row with the previous row and update the running maximum where it is larger.
Please do not shout. (All capitals = shouting.)
Why do you specifically want to use a Transformer stage? It is more usual to use an Aggregator stage to find a maximum (or perhaps an SQL query).
It can, of course, be achieved, using the fact that stage variables are evaluated in the order in which they appear in the grid, so that a value from the previous row can be remembered. Therefore you only need to compare the current row with the previous row and update the running maximum where it is larger.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia