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...
column import output link shows only one row
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 104
- Joined: Sat Dec 24, 2005 1:26 am
- Location: Bengaluru
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 34
- Joined: Tue Feb 26, 2013 9:36 am
- Location: Chicago