Hi ,
I think that this topic has already been discussed, but I still dont know how t o do that..?
I have a single row comming in which can have upto 5 codes in that. Sometimes it may have one cd, sometimes all of them.
There is only 1 target column for that, so i need to send them all to one column, and an Id is automatically generated for each comming in row..
Can someone help me on how I can achieve this. It is somethin like a horizontal pivot thin. There is a Pivot stage, will that help??
thanks,
How to split single row into multiple rows in datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 145
- Joined: Fri May 02, 2003 9:59 am
- Location: Seattle, Washington. USA
Re: How to split single row into multiple rows in datastage
You would use the pivot stage. It is a little tricky to use but there are several good discussions on it in theis forum.
Shawn Ramsey
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: