sub columns to new columns

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
chvenkat.v
Participant
Posts: 94
Joined: Fri Dec 14, 2007 3:22 am

sub columns to new columns

Post by chvenkat.v »

hi

i am reading data from oracle like this

empno1 sal

1 10000
1 10000
1 10000
1 12000
here 4 sal are the months of jan.,feb., mar., apr...

output like this report

empno jan feb mar apr may


so, pls help me how get this output using in datastage.
thnks
venkat
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Vertical pivoting (rows to columns) can be performed in DataStage using a number of techniques. Search DSXchange for "vertical pivot".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”