How to Vertical Pivot
Posted: Tue Mar 18, 2014 3:32 pm
Can anyone explain how to do a vertical pivot for the server addition? All my searches are turning up example for the parallel edition. I'm assuming the pivot stage can do horizontal and vertical. I've used it for horizontal pivoting, so I've been testing putting different values in the derivation of the output of the stage.
To help illustrate here' the source format:
And the destination format:
To help illustrate here' the source format:
Code: Select all
ID_Column,Column_Name,Column_Value
1,First_Name,Joe
1,Last_Name,Smith
1,Color,Blue
2,First_Name,Amy
2,Last_Name,Joe
2,Color,Green
Code: Select all
ID_Column,"First_Name","Last_Name","Color"
1, Joe, Smith, Blue
2, Amy, Joe, Green