DSXchange

Posted: **Mon Nov 10, 2008 8:29 pm**

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???

Posted: **Mon Nov 10, 2008 9:17 pm**

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.

Posted: **Mon Nov 10, 2008 9:50 pm**

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

DSXchange

Vertical pivoting of data

Vertical pivoting of data