DSXchange

HOW TO FIND OUT MAX SALARY USING TRASFORMER STAGE
HELP ME









THANKS IN ADVANCE

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.

interview question?

do you know how to find the MAX salary, similar logic will apply in your job

Use Stage variable.
compare prev to curr
set max
Save previouse value