Five Stars

Iterate through join results in tMap component

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.
5 REPLIES
Moderator

Re: Iterate through join results in tMap component

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Iterate through join results in tMap component

This is the current design.
Four Stars

Re: Iterate through join results in tMap component

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
Moderator

Re: Iterate through join results in tMap component

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Iterate through join results in tMap component

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".