One Star

How can I splitt an inputrow into twi outputrows

Hello,

how do I divide a line into several lines?
Example:
InputFile:
name1, email3
name2, email3
name2, email3
OutputFile:
name1,
email1,
name2
email2,
name3,
email3
How can I achieve this?? With a tMap I can change the ordering of the row, but I want to splitt the row into two new rows.
Sorry for my english.
Thank You very much.
6 REPLIES
One Star Lie
One Star

Re: How can I splitt an inputrow into twi outputrows

One Star

Re: How can I splitt an inputrow into twi outputrows

Hello Lie,
thanks for your reply, but is it possible that you can describe your answer a little more detail?
In the tMapView I have on the left Site the rowdescribtion of the inputfile and on the right-Site are two output-Tables.
And what are next? I'm so sorry.
Thank you very much.
Balian
One Star

Re: How can I splitt an inputrow into twi outputrows

Hello Lie,
the spliting of the row is completed. The result are two files like this:
File1:
name1,
name2
File2:
email1,
email2
But how can i merge both files or is it posssible to merge the rows without creating of two tempfiles?
Sorry for my english. I hope you understand me. :-)
Best Regards!
One Star Lie
One Star

Re: How can I splitt an inputrow into twi outputrows

Hi
You can use a tUnite component to merge your rows.

Regards,
Lie
Seven Stars

Re: How can I splitt an inputrow into twi outputrows

Rather than sending the two tMap outputs to a file and then tUniting them, you can unite them directly in the tMap: when creating the second output within tMap just select the "Create join table from" option rather than the default "New output" option. There will then be only one flow out of the tMap but it will include the rows from both of the output tables within tMap.
Seven Stars

Re: How can I splitt an inputrow into twi outputrows

There is also from v4.2.0, the tSplitRow component...