Pivot in datastage 8.1

ds_8112 · Post by **ds_8112** » Tue Jan 28, 2014 8:01 am

Hi,
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)

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

chulett · Post by **chulett** » Tue Jan 28, 2014 8:40 am

So why not use the Enterprise stage? Did you try it and have issues?

rkashyap · Post by **rkashyap** » Tue Jan 28, 2014 10:51 am

See the link for a workaround ...

viewtopic.php?t=118685

ds_8112 · Post by **ds_8112** » Thu Jan 30, 2014 2:57 am

chulett wrote:So why not use the Enterprise stage? Did you try it and have issues?

I tried Pivot enterprise stage , there is a property where in we can select the Pivot type as vertical or horizontal but when we select vertical the other options (which should be applicable for vertical pivoting) doesn't change..

ie it seems 8.1 only supports horizontal pivot..

Anyways I would like to thank you for taking out time suggesting...

ds_8112 · Post by **ds_8112** » Thu Jan 30, 2014 3:02 am

rkashyap wrote:See the link for a workaround ...

viewtopic.php?t=118685

Thanks a lot for the information.. I will try this out...

chulett · Post by **chulett** » Thu Jan 30, 2014 8:28 am

Ah yes, 8.1... getting a little long in the tooth and you're right, doesn't support that 'direction'. Later versions correct this.