I wanted to do vertical pivot on incoming data .
I am using datastage 8.1 version and it seems vertical pivot is not
supported in this version (although there is an option to select pivot type as vertical in the Pivot Enterprise stage)
![Sad :(](./images/smilies/icon_sad.gif)
My Input will look some thing like this :
Col1,Col2
1,A
1,B
1,C
and I want the output to be as
Col1,V1,V2,V3
1,A,B,C
Can any body please let me know if there is any other way to achieve this ?
Regards,
ds_user