Pivot stage

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
Hope
Participant
Posts: 97
Joined: Sun May 13, 2007 2:51 pm
Contact:

Pivot stage

Post by Hope »

I have an input as
col1 col2 col3 col4 col5
57 58 59 60 61.

I want the output as
col1 = 57
col2 = 58
col3 = 59
col4 = 60
col5 =61

Can I use a pivot stage for this?.If so how can I use.I dont have the plug-in documentation installed for this.

Please help.
us1aslam1us
Charter Member
Charter Member
Posts: 822
Joined: Sat Sep 17, 2005 5:25 pm
Location: USA

Post by us1aslam1us »

Yes Pivot stage can be used in your scenario. Do a search on "Pivot" to know the implemenation.
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
us1aslam1us
Charter Member
Charter Member
Posts: 822
Joined: Sat Sep 17, 2005 5:25 pm
Location: USA

Post by us1aslam1us »

Yes, Pivot stage can be used in your scenario. Do a search on "Pivot" to know the implemenation.
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
Post Reply