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???
Vertical pivoting of data
Moderators: chulett, rschirm, roy
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
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