topic Re: Iterate through join results in tMap component in Talend Studio

Iterate through join results in tMap component

Anonymous — Fri, 13 Jun 2014 04:16:50 GMT

Is there any method to iterate the results resulted by the join in tMap?
I need to iterate through the results from the join of row2 and row3 first and then continue with other joins. In my case row2 and row5.

Re: Iterate through join results in tMap component

Anonymous — Fri, 13 Jun 2014 04:21:03 GMT

Hi,
Are you looking for TalendHelpCenter:tFlowToIterate which iterates on the input data and generates global variables?
What's your current job design?
Best regards
Sabrina

Re: Iterate through join results in tMap component

Anonymous — Fri, 13 Jun 2014 04:25:10 GMT

This is the current design.

Re: Iterate through join results in tMap component

Anonymous — Fri, 13 Jun 2014 06:45:10 GMT

Hi,
There are two components
- https://help.talend.com/search/all?query=tIterateToFlow&content-lang=en
- https://help.talend.com/search/all?query=tFlowToIterate&content-lang=en
Use the component after tMap... See above scenarios and check which is suitable for you.
Thanks
Vaibhav

Re: Iterate through join results in tMap component

Anonymous — Fri, 13 Jun 2014 11:20:26 GMT

Hi,
The screenshot you uploaded is tMap editor screenshot. Could you please share your whole job design screenshots? Is the component tFlowToIterate suitable for your use case?
What's you expected result? Elaborating your case with an example with input and expected output values will preferred.
Best regards
Sabrina

Re: Iterate through join results in tMap component

Anonymous — Tue, 17 Jun 2014 02:28:36 GMT

Hi Sabrina,
Here is my requirement and the current job I have.
I am currently working on a data integration project and I have given a huge excel mapping file. I have imported that to
a table in the database and DEF represents that table.
ABC is a table from the source database.
NOTE: The new table name in the given mapping table should be "XYZ".