Create multiple output rows for one input row

[_AnonymousUser]

Hello,
i'm new in working with Talend Open Studio (TOS opensource edition).
In our datamigration project we have the following requirement in data transformation.
we have a input table with the folling structure:
orderid | descritpion | responsible| executor | ...
--------------------------------------------------------
4711 | bla1 | Frank | Peter
4712 | blabla | John |
4713 | sdjfklsj | James | Bart
what i need as an output must look like this:
id | orderid | function | name
-------------------------------------
0815 | 4711 | responsible | Frank
0816 | 4711 | executor | Peter
0817 | 4712 | responsible | John
0818 | 4713 | responsible | James
0819 | 4713 | executor | Bart
So i have to create a output row for a column content and the output row has a foreign key (orderid) to the input table. The id in the output table can be generated. With our own ETL Tool we can fit these requirements and i am sure TOS can also.
But how?

[alevy]

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

[_AnonymousUser]

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.
Thanks for the answer... this worked for me