Hi,
I have record in the following format
Id1:Value1
id2: value2
id3:value3
id1:value1
id2:value2
id3:value3
I have to parse these records.
Which stage i should use in data stage. If there is no stage available then what could be the workaround for this.
Thanks in advance,
Burendra
Parsing of the record
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
To clarify, you want to pivot rows into columns? Is that correct? The technique is called "vertical pivoting", and a search of the forum for that term will reveal a number of ways that it can be done with DataStage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.