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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
EspenH
Partner - Contributor III
Partner - Contributor III

From JSON to Flat, how to merge file when split loop is used?

Hi

Quite new to Talend and data mapper.

I have a nested JSON file with two different loop elements. If i try to use nested loop there is a conflict between the looping elements. I am guessing i need to use "split from loop" to handle each loop element separately.

This seems to be working, but i get separate result sets, how can I merge the these lines in Talend?

Please advise...

Labels (4)
2 Replies
Sonal_Reddy_18
Partner - Contributor II
Partner - Contributor II

Hi ,

Can you please post a sample json with your structure

EspenH
Partner - Contributor III
Partner - Contributor III
Author

Thank you for responding.

Please see attached JSON file.

When I clean the structure it looks like this (input and output structure from data mapper):

EspenH_0-1735929409721.png