DSXchange

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.

My preference would be one Transformer stage.

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

Any specific reasons?

What if the Row splitting column is only one?

I also have same question- any specific reason?

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

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.

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