hii all
My input is like - Abc,Bcd,Cde,Fgh
i have to parse this and perform lookups separately for each of these (number of comma separated values is not fixed)
Also i need to insert lookup id's and some other data individually into my db
so in db entries will be like
11(Lookup id of Abc) 20 30 40
82(Lookup id of Bcd) 20 30 40
43(Lookup id of Cde) 20 30 40
94(Lookup id of Fgh) 20 30 40
parsing comma separated values coming from xml
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 27
- Joined: Thu Aug 09, 2012 4:55 am
- Location: bangalore
Not sure that where it is coming from matters, however not being a fixed number can unless you are aware of the maximum number it could be. Then you can perform a horizontal Pivot and filter out the 'empty' occurrences afterwards.
There are some alternatives but first curious if you are actually using a Server job as the post is marked?
There are some alternatives but first curious if you are actually using a Server job as the post is marked?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 27
- Joined: Thu Aug 09, 2012 4:55 am
- Location: bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No more light required. Do the pivot as Craig suggested (using the Pivot stage), then you can do your individual lookups. Handle the failed lookups however you wish in the Transformer stage.
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.