Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.
Labels (2)
5 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

This is the current design.
0683p000009MEP6.png
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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".
0683p000009MEOs.png 0683p000009MEPB.png