Topic
No replies
ManglamKumar
ManglamKumar
1 Post
ACCEPTED ANSWER

Pinned topic Transpose of Row into Column

‏2012-06-25T13:16:12Z |
Hello Everyone,

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.
Input:
A B C
D E F
Output:
A D
B E
C F
Can we use Pivot Stage in this requirement? If yes, how to implement logic into derivation section of pivot stage?
Appreciate any pointers!
Thanks,
Manglam