Hi
I have a requirement to process following:
I/P:
A1|val1;val2;val3.....;valn|C3
B1|val2;var3;var5;..........;varn|C3
O/P:
A1|Val1|C3
A1|val2|C3
...
...
A1|valn|C3
B1|val2|C3
..
..
..
B1|varn|C3
Hear the 2nd column has unknown number of values which has to splitted across for each of the value in column 1
Please help
Pivoting-unknown number of columns
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The Pivot stage needs a fixed number of columns... as in the maximum you could possiblty get. Then as Ray notes you'd need to filter out the unused values (the NULLS) post-pivot. It works but you can end up creating a ton of records to filter out.
Without transformer looping you may need to do this outside of DataStage, something at the O/S level perhaps.
Without transformer looping you may need to do this outside of DataStage, something at the O/S level perhaps.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers