pivot dyanmic user

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
harryhome
Participant
Posts: 112
Joined: Wed Oct 18, 2006 7:10 am

pivot dyanmic user

Post by harryhome »

how to use pivot for generating dyanmic number of columns?


e.g.

for i/p

id|d1,d2,d3|status

where d1,d2,d3 is dyanamic (can be d1,d2,d3,d4)

desired o/p

id|d1|status
id|d2|status
id|d3|status




pz help
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Do you know the maximum occurances?
-craig

"You can never have too many knives" -- Logan Nine Fingers
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 »

You have an ongoing thread on this topic, in which you will find an answer. The current thread is redundant.
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> Infosphere DataStage Server Edition”