Pivoting

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
karthegx
Participant
Posts: 27
Joined: Wed Sep 06, 2006 1:48 am

Pivoting

Post by karthegx »

Hi,

I have need clarification to do this scenario,

My input is this.......

Col1 Col2 Col3

1 A RT

1 A PT

I need to have output as this....

Col1 Col2 Col3 Col4

1 A RT PT

Can anyone help on this..

Thanks in Advance.......
kartheek
ShaneMuir
Premium Member
Premium Member
Posts: 508
Joined: Tue Jun 15, 2004 5:00 am
Location: London

Post by ShaneMuir »

Search the forum for "Vertical Pivot".

I think there is an explanation in the FAQ section also
Raghavendra
Participant
Posts: 147
Joined: Sat Apr 30, 2005 1:23 am
Location: Bangalore,India

Post by Raghavendra »

Do you what is the maximum number of rows that has to be converted into columns?
Raghavendra
Dare to dream and care to achieve ...
Post Reply