DSXchange

Hi ,
Can anybody please tell me about how to use row splitter stage in job .
Actually i am getting problem for the output link of this stage . I dont
know how to specify the output columns for this stage . Do we have to give
derivations for the output columns ? If yes , then what should i write in
the derivation ?

Welcome! First question would be - have you read the documentation on the stage? You should be able to find a 'rowsplit.pdf' in the Docs directory on your pc. For example, one question answered there - the derivation column is not used.

yes i have already read the documentation but i am a new user

New but did you get any training or were you just thrown straight into the deep end of the pool? Per the documentation, the RowSpitter stage "Reads one row at a time, splits the data fields contained in a string into a number of columns, and then writes the columns to the output link". In other words it parses one column/field into multiple columns/fields.

Why don't we start with you explaining what your job is trying to accomplish and some idea what your design and data look like at the moment? Perhaps that stage is not appropriate for the task at hand.

Yes, you do need to specify how the Row Splitter stage is to parse the input field. How have you done this? It is usually done with metadata definitions.

i have same problem. I want to split a char row into two char rows. I 've specified the row(which i want to split) as the stage input and the two rows(which i want to obtain) as stage ouputs, but my work doesn't run.

hi warice can you give your input string and what you want in output plus what delimiter you have given in output tab of Row_Splitter stage.