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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
CJIGA
Contributor II
Contributor II

Flat to XML with multiples loop in same level

Please, we need to create a mapper to convert Flat to XML with multiple loops at the same level. I attached the example that I am trying to do.

 

@hnie

Labels (2)
1 Solution

Accepted Solutions
Haitao
Creator
Creator

The input here contains rows of different countries and their languages and cities.

I think you need to use a 1st map to group countries to the output then a 2nd map to distinct languages and cities of each country.

 

Please see the attachment for details.

 

Steps below explain how to get it

  • 1st map to group countries

0683p000009M0bj.png0683p000009M0bt.png0683p000009M0by.png

  • 2nd map to distinct languages and cities

0683p000009M0c8.png0683p000009M0Y2.png0683p000009M0cN.png

  • to chain 1st map with the 2nd

0683p000009M0Ma.png0683p000009Lzot.png


Demo.zip

View solution in original post

1 Reply
Haitao
Creator
Creator

The input here contains rows of different countries and their languages and cities.

I think you need to use a 1st map to group countries to the output then a 2nd map to distinct languages and cities of each country.

 

Please see the attachment for details.

 

Steps below explain how to get it

  • 1st map to group countries

0683p000009M0bj.png0683p000009M0bt.png0683p000009M0by.png

  • 2nd map to distinct languages and cities

0683p000009M0c8.png0683p000009M0Y2.png0683p000009M0cN.png

  • to chain 1st map with the 2nd

0683p000009M0Ma.png0683p000009Lzot.png


Demo.zip