Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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