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
askvishal
Participant
Posts: 8
Joined: Wed Oct 23, 2013 5:52 am
Location: Chennai

Pivoting

Post by askvishal »

Hi,

Please help me developing a parallel job for the following set of input-output data.

Input:-

Name Subject Marks
XYZ Maths 100
XYZ Science 100
XYZ History 100


Output:-
Name Maths Science History
XYZ 100 100 100

Please note the Subject column can increase dynamically


Thanks,
Vishal
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

Welcome aboard.

Do you have a maximum number of columns defined? Try searching for Horizontal pivot on the search page. Hope you will get what you need.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
Post Reply