https://community.qlik.com/t5/Talend-Studio/Generating-XML-with-2-independant-loops/m-p/2284093#M57863 <P>Hi,</P><P>A XML document have to be created with 2 <STRONG>distinct</STRONG> loops.</P><UL><LI>RESERVED_MATERIAL</LI><LI>BY_PRODUCT</LI></UL><P>I use a tXMLMap with 2 input links</P><UL><LI>main: aggPO-&gt;BY-PRODUCT</LI><LI>lookup : stock-&gt;RESERVED_MATERIALS</LI></UL><P>But it generates a cartesian product.</P><P>I a have enclosed the result wanted, and the job created.&nbsp;</P><P>&nbsp;</P><P>Could you give me some ideas on how to make two loops please?</P><P>Does DataMapper + tHMap would be adapted?</P><P>Should I generate the XML in two steps, one for each loop?</P><P>&nbsp;</P><P>Thank you</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 02:46:41 GMT Anonymous 2024-11-16T02:46:41Z https://community.qlik.com/t5/Talend-Studio/Generating-XML-with-2-independant-loops/m-p/2284093#M57863 <P>Hi,</P><P>A XML document have to be created with 2 <STRONG>distinct</STRONG> loops.</P><UL><LI>RESERVED_MATERIAL</LI><LI>BY_PRODUCT</LI></UL><P>I use a tXMLMap with 2 input links</P><UL><LI>main: aggPO-&gt;BY-PRODUCT</LI><LI>lookup : stock-&gt;RESERVED_MATERIALS</LI></UL><P>But it generates a cartesian product.</P><P>I a have enclosed the result wanted, and the job created.&nbsp;</P><P>&nbsp;</P><P>Could you give me some ideas on how to make two loops please?</P><P>Does DataMapper + tHMap would be adapted?</P><P>Should I generate the XML in two steps, one for each loop?</P><P>&nbsp;</P><P>Thank you</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 02:46:41 GMT https://community.qlik.com/t5/Talend-Studio/Generating-XML-with-2-independant-loops/m-p/2284093#M57863 Anonymous 2024-11-16T02:46:41Z