Row Splitter vs Transformer with FIELD function

psluser · Post by **psluser** » Fri Jun 13, 2008 12:38 am

hi,

When should we use row splitter vs a transformer with field functions to get individual columns within a string.

My requirement is to convert four columns below to:
"2121,A,B","A,B,Y","3213,2231,AC",21

to 8 columns, splitting column 2 and column 3 above:

"2121,A,B",A,B,Y,3213,2231,AC,21

Should I use two row splitters, one for column2 and second for column3 or one transformer with field functions? Though I have shown above that both columns are to be split into 3 columns each, its different for different jobs varying from 3 to 14. That is in some of my jobs second column is to be split into 14fields.

ray.wurlod · Post by **ray.wurlod** » Fri Jun 13, 2008 5:50 am

My preference would be one Transformer stage.

chulett · Post by **chulett** » Fri Jun 13, 2008 6:34 am

I've never had a need for the Row Splitter stage. My preference would be the same as Ray's.

psluser · Post by **psluser** » Fri Jun 13, 2008 7:47 am

Any specific reasons?

ag_ram · Post by **ag_ram** » Sat Jun 14, 2008 5:21 am

What if the Row splitting column is only one?

I also have same question- any specific reason?

chulett · Post by **chulett** » Sat Jun 14, 2008 6:59 am

Well... for me, it's a personal preference, so no.

ray.wurlod · Post by **ray.wurlod** » Sat Jun 14, 2008 4:12 pm

When it's only one (which was not the original question, by the way), there will not be much to choose from in terms of number of stages in the job. My personal preference is guided by the relative newness of the Row Splitter stage; the Transformer has been around a lot longer and has had a better chance of having had all the bugs ironed out of it.

ag_ram · Post by **ag_ram** » Sun Jun 15, 2008 4:57 am

Thanks chulett and ray.wurlod for sharing your personal preference.