DSXchange

Hi, using import columns data to get column data from a raw i/p string (comma delimited, pipe as record separator)

I/p:
xyse,scsye,saed,se,|asdfwe,sed,ased,sed,

expected o/p:
RECORD1 as
col1:xyse
col2:scsye
col3:saed
col4:se
col5:

RECORD2 as
col1:asdfwe
col2:sed
col3:ased
col4:sed
col5:

but, output link shows only 1 row... shouldn't be showing as 2 rows?
and when i am writing the output into a unix file..its showing as input string..

xyse,scsye,saed,se,|asdfwe,sed,ased,sed,

I have specified
Final delimiter as nono
Record delimiter as |
Filed delimiter as comma

is there any setting missing at column import stage? having hard time dealing with it...

That stage is strictly one-to-one, there's no facility to ouput multiple records. You'd need to split it in two first and send both to it, which could be as simple as Field() in a transformer with two output links followed by a Funnel.

Column Import reads the multiple column file and generates a single row out of it. You can further use transformer to split the single row into multiple columns.

Column Export will read a single input and splits it to multiple output columns.