topic Re: Create multiple output rows for one input row in Talend Studio

Create multiple output rows for one input row

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

Re: Create multiple output rows for one input row

Anonymous — Wed, 26 May 2010 11:05:46 GMT

Hi
You can divide by using a tMap in two flows. (one with responsible & one with executor) then output both in temp files. Then you load the temp files and "unite" flows.
You can also unite your flows in a single temp file.

Regards,
Lie

Re: Create multiple output rows for one input row

_AnonymousUser — Thu, 27 May 2010 09:08:47 GMT

Thanks Lie, it work's !

Re: Create multiple output rows for one input row

Anonymous — Thu, 27 May 2010 11:20:34 GMT

how can I perform reverse process where I have multiple rows for particular id. i want all record to one id should be in one row.I dont want to store in a file system

Re: Create multiple output rows for one input row

Anonymous — Thu, 27 May 2010 11:32:30 GMT

Shaky :
You can use a tMap.
row1
id | column1
row2
id | column2
output
id | column1 | column2

Map row1.id to row2.id and output.id
Then map row1.column1 to output.column1 and row2.column2 to output.column2.
The reverse process is easy

Re: Create multiple output rows for one input row

Anonymous — Thu, 27 May 2010 13:22:55 GMT

Did not understood how to do using tMap. Can you explain with screenshot? it would be gr8 help.

Re: Create multiple output rows for one input row

Anonymous — Thu, 27 May 2010 13:33:03 GMT

rowExecutor :
1|executor|Millard
2|executor|Harry
3|executor|George
4|executor|James
5|executor|Harry
rowManager :
1|manager|John
2|manager|Rutherford
3|manager|Thomas
4|manager|John
5|manager|Grover

Output :
1|Millard|John
2|Harry|Rutherford
3|George|Thomas
4|James|John
5|Harry|Grover

Hope my exemple is clear enough.

Re: Create multiple output rows for one input row

Anonymous — Thu, 27 May 2010 13:52:23 GMT

i have input like
id:1
name:ss
age:15
id:2
name:as
age:14
How can I do this in one row for each record

Re: Create multiple output rows for one input row

Anonymous — Thu, 27 May 2010 14:19:54 GMT

See my example below. This is the way I see it.
Use a tFileInputDelimited to separate your keys and values (set the separator to ":").
Set ids yor each of your rows as in my example below.
Then you could use my example above to unite your rows.

Hope it helps.

Re: Create multiple output rows for one input row

alevy — Thu, 17 Mar 2011 00:53:09 GMT

You can divide by using a tMap in two flows. (one with responsible & one with executor) then output both in temp files. Then you load the temp files and "unite" flows.

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: Create multiple output rows for one input row

alevy — Sun, 12 Jun 2011 03:32:14 GMT

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

Re: Create multiple output rows for one input row

_AnonymousUser — Wed, 23 Nov 2016 12:21:40 GMT

You can divide by using a tMap in two flows. (one with responsible & one with executor) then output both in temp files. Then you load the temp files and "unite" flows.