vertical pivot

[vsurap]

If POS is fixed (i.e only M/D/R) then you can use the below logic using Join stages.

1) Splitt the Input data into 3 datasets/Files, one for each POS
2)Do a full outer join to Join any two datasets.(take Dataset M and Dataset D)

3)Do the Null handling in a transformer.

4)Do a Full outer to join the Output from Transformer and remaing Input data set (dataset R) and do the required null handling.