hi,
how to split multiple records based on delimiter
source is 1#2#3#4#5 ..n
it should be present in target like this
Ans
-------
1
2
3
4
5
.
.
n
Regds
Ramesh
split multiple rows
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 34
- Joined: Fri May 16, 2008 6:24 am
-
- 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:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Convert the # to @VM and load into a hashed file with a key generated as @OUTROWNUM. Then read from the hashed file dynamically normalized on your multi-valued column. You will need to set up the table definition with the "supports multi-valued columns" check box selected.
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.
-
- Premium Member
- Posts: 34
- Joined: Fri May 16, 2008 6:24 am