3 output link in a transformer
link1 has 5 columns , like:
1,2,3,5,4
22,33,34,16,33
link2 has 8 columns :
1,2,4,6,5,4,3,5
100,34,23,12,55,65,77,44
link3 has 7 columns:
1,1,34,33,55,4,3
2,4,42,32,44,55,33
i wanna write them into a single file:
1,2,3,5,4
22,33,34,16,33
1,2,4,6,5,4,3,5
100,34,23,12,55,65,77,44
1,1,34,33,55,4,3
2,4,42,32,44,55,33
what kind of stage i can use to get this?
please help!
write data with different number of columns to a single file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 26
- Joined: Mon Nov 19, 2007 2:55 am
- Location: Hangzhou
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You could use a Column Export stage to create a single VarChar column on each link (containing a comma-delimited string), and run the three links into a Funnel stage to combine them.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.