parsing comma separated values coming from xml

roshanearly · Post by **roshanearly** » Mon Oct 14, 2013 12:52 am

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

chulett · Post by **chulett** » Mon Oct 14, 2013 9:00 am

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?

roshanearly · Post by **roshanearly** » Tue Oct 15, 2013 1:04 am

hii chulett

the maximum number is fixed ie- 30 .yes i am using a server job .kindly throw some more light on it

ray.wurlod · Post by **ray.wurlod** » Tue Oct 15, 2013 1:50 am

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.

chulett · Post by **chulett** » Tue Oct 15, 2013 7:27 am

Other options, like Transformer Looping, are not available in a Server job. That's why I wanted to double-check.