I am new to Data Stage.I came across 1 requirement where i need to transpose the Row to column. Below is sample of data as input and output.
A B C
D E F
Can we use Pivot Stage in this requirement? If yes, how to implement logic into derivation section of pivot stage?
Appreciate any pointers!