DSXchange

Hi all,
I have a requirement of Horizontal pivot i.e c\Columns to Row conversion.The logic to be achieved is explained below

i/p:

ID COL1 COL2 COL3 COL4
1 10 20 30 40
2 11 25 32 15
3 45 56 23 100

Required O/p:

ID CHAR1 CHAR2
1 COL1 10
1 COL2 20
1 COL3 30
1 COL4 40
2 COL1 11
2 COL2 25
2 COL3 32
2 COL4 15
3 COL1 45
3 COL2 56
3 COL3 23
3 COL4 100

Please help me in achieving this output using Pivot Stage.


Regards,
Balakrishna

Just talked about something very much like this:

viewtopic.php?t=128627

Will any one please explain about using the Output Deviation in Pivot Stage


Regards,
Balakrishna

Please neglect my earlier post.


Will any one explain me the logic defined in the above link mentioned.I didn't understand what they meant by using a particular code in Output Column Derivation

You need to add fields to your flow that hard-code your column names and then pivot them along with your data.