Aggregate columns based on the condition

[Vino_joe84]

Hi,

Help us to implement the logic. My Input records is in below.

ID name Sal Dept Status
10 vin 1000 eee d
200 kiui 1000 cs e
300 AV 152 cs d
300 hfajs 600 cs e
400 afd 900 eee f
500 afd 800 cs f

My output should be like this
D_Status_Sal E_status_Sal F_Status_Sal eee_Dept_sal cs_Dept_sal
1152 1600 1700 1900 2552

We tried to use the stage variable in the transformer and use the aggregator. It is not giving the required output.

Please let us know what needs to be done.

[ray.wurlod]

Group by Status summing Sal, then vertical pivot.