topic Re: How can I splitt an inputrow into twi outputrows in Talend Studio

How can I splitt an inputrow into twi outputrows

_AnonymousUser — Sat, 16 Nov 2024 13:25:09 GMT

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.

Re: How can I splitt an inputrow into twi outputrows

Anonymous — Thu, 27 May 2010 09:27:16 GMT

Hi,
Check https://community.talend.com/t5/Design-and-Development/Create-multiple-output-rows-for-one-input-row/td-p/64072

Regards,
Lie

Re: How can I splitt an inputrow into twi outputrows

_AnonymousUser — Thu, 27 May 2010 11:37:13 GMT

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

Re: How can I splitt an inputrow into twi outputrows

_AnonymousUser — Thu, 27 May 2010 12:01:53 GMT

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!

Re: How can I splitt an inputrow into twi outputrows

Anonymous — Thu, 27 May 2010 13:24:10 GMT

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

Regards,
Lie

Re: How can I splitt an inputrow into twi outputrows

alevy — Thu, 17 Mar 2011 00:49:44 GMT

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.

Re: How can I splitt an inputrow into twi outputrows

alevy — Sun, 12 Jun 2011 03:33:23 GMT

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