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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
EspenH
Partner - Contributor III
Partner - Contributor III

From JSON to flat file with two nested loops (in data mapper)

I have a datas tructures as below, which showes both the input and the output structure in data mapper:

EspenH_0-1735831395560.png

I need to loop both hours [0:*] and meteringPoints[0:] in same output.

When i create one loop with hours [0:*] its fine, but when I try to create an additional loop with meteringPoints[0:] the only option is to aggregate alle the values in the last loop:

EspenH_1-1735831647913.png

I have tried to do a "split loop", but then i get separated results and I need to hav them combined.

I belive this is quite simple, but I have not been able to find the solution.

Any of you experts out there who know how to do this???

Labels (3)
1 Reply
EspenH
Partner - Contributor III
Partner - Contributor III
Author

It seems the solution is to use split loop, but does please do any one know how to merge in end result?