https://community.qlik.com/t5/Talend-Data-Catalog/Flat-to-XML-with-multiples-loop-in-same-level/m-p/2325108#M346 <P>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.</P> <P>&nbsp;</P> <P><A href="https://community.qlik.com/s/profile/0053p000007LLUzAAO" target="_blank">@hnie</A></P> Sat, 16 Nov 2024 07:25:05 GMT CJIGA 2024-11-16T07:25:05Z https://community.qlik.com/t5/Talend-Data-Catalog/Flat-to-XML-with-multiples-loop-in-same-level/m-p/2325108#M346 <P>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.</P> <P>&nbsp;</P> <P><A href="https://community.qlik.com/s/profile/0053p000007LLUzAAO" target="_blank">@hnie</A></P> Sat, 16 Nov 2024 07:25:05 GMT https://community.qlik.com/t5/Talend-Data-Catalog/Flat-to-XML-with-multiples-loop-in-same-level/m-p/2325108#M346 CJIGA 2024-11-16T07:25:05Z https://community.qlik.com/t5/Talend-Data-Catalog/Flat-to-XML-with-multiples-loop-in-same-level/m-p/2325109#M347 <P>The input here contains rows of different countries and their languages and cities.</P> <P>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.</P> <P>&nbsp;</P> <P>Please see the attachment for details.</P> <P>&nbsp;</P> <P>Steps below explain how to get it</P> <UL> <LI>1st map to group countries</LI> </UL> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="01.png" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M0bj.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/146440iB94F8F2C448CA0FC/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M0bj.png" alt="0683p000009M0bj.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="02.png" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M0bt.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144274iA3B047EC0783387F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M0bt.png" alt="0683p000009M0bt.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="03.png" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M0by.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157851i8E17FB3BF3650112/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M0by.png" alt="0683p000009M0by.png" /></span></SPAN></P> <UL> <LI>2nd map to distinct languages and cities</LI> </UL> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="04.png" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M0c8.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154570i095273345AAAFE6F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M0c8.png" alt="0683p000009M0c8.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="05.png" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M0Y2.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133916iCD4F8CDDF9B01E87/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M0Y2.png" alt="0683p000009M0Y2.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="06.png" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M0cN.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/155306i22AC3C0AB84F5ED2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M0cN.png" alt="0683p000009M0cN.png" /></span></SPAN></P> <UL> <LI>to chain 1st map with the 2nd</LI> </UL> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="07.png" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M0Ma.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/153444iA298FEF232D1040C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M0Ma.png" alt="0683p000009M0Ma.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="08.png" style="width: 271px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lzot.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/143713i03D56DA017E85575/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lzot.png" alt="0683p000009Lzot.png" /></span></SPAN></P><BR /><A href="https://community.qlik.com/legacyfs/online/tlnd_dw_files/0683p000009Lu3u">Demo.zip</A> Wed, 24 Oct 2018 11:08:25 GMT https://community.qlik.com/t5/Talend-Data-Catalog/Flat-to-XML-with-multiples-loop-in-same-level/m-p/2325109#M347 Haitao 2018-10-24T11:08:25Z