Vertical pivoting of data

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
klsp123
Participant
Posts: 1
Joined: Mon Nov 10, 2008 8:17 pm

Vertical pivoting of data

Post by klsp123 »

Hi I need help on vertical pivot of source data using datastage.

source Data:
ID type
100 1
100 2
101 1
101 2
102 1
102 3


Target data should be:(Need to send)

ID Type1 Type2 Type3
100 1 2 -
101 1 2 -
102 1 - 3


How could we acheive this in Datastage???
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Welcome. First suggestion? Search the forums here for 'vertical pivot', you're not the first to ask - and it's been discussed here before. A lot.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Editor
Posts: 265
Joined: Wed Oct 30, 2002 11:19 am
Location: Dallas TX
Contact:

Post by Editor »

KLSP123,

Welcome to the forum. We encourage new members. Please update your profile with honest and accurate information. The members that take the time to answer you or help you expect it.

I will be happy to alert the members when you have completed your profile.

Editor.

visit our new site for added content www.dsxchange.net
Post Reply