How to convert multiple coloums to rows

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
sirishds
Participant
Posts: 18
Joined: Sat Jun 12, 2010 11:28 pm

How to convert multiple coloums to rows

Post by sirishds »

Hi,

I have a suitation where i need to convert rows into coloums.Please find the details below


Source
target
Custno custPreferences 1,2,3
1 2 2,5,6
1 3
2 5
2 6


How do i perform it by transformer.

Thanks in advance
Sirishds
sirishds
Participant
Posts: 18
Joined: Sat Jun 12, 2010 11:28 pm

Post by sirishds »

sorry i will post again my question is not clear
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

:!: Next time, don't post it again, simply go back and edit your post for clarity. Nothing here is cast in stone.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply