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

Announcements
Join us in Bucharest on Sept 18th 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