https://community.qlik.com/t5/Talend-Studio/Combining-multiple-XML-into-one-using-the-same-schema/m-p/2357685#M122900 <P>Hello, </P><P></P><P></P><P>I'm currently facing a situation where I have several XML files that conform to a shared schema. However, each of these files holds data related to a distinct parent element within the schema. My goal is to merge these files into a unified tFileOutputXML, and I'm utilizing a tXMLMap for this task. Unfortunately, the result I'm getting seems to be duplicating the entire schema for each individual row of data that I input.</P><P></P><P></P><P>Could you kindly guide me on the steps to rectify this issue? I aim to generate a valid XML output that adheres accurately to the XSD Schema I imported. For additional clarity, I've attached some screenshots for your reference.</P><P></P><P></P><P>tXMLMap</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000nSAc7AAG.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134459i909B98A3FCB3AADA/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000nSAc7AAG.png" alt="0695b00000nSAc7AAG.png" /></span></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000nSAcRAAW.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144969i210663121278012E/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000nSAcRAAW.png" alt="0695b00000nSAcRAAW.png" /></span></P><P>tFileInputXML_1</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000nSAfBAAW.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/137326i4034689A462E7B1C/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000nSAfBAAW.png" alt="0695b00000nSAfBAAW.png" /></span></P><P></P><P></P><P>tFileInputXML_2</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000nSAfpAAG.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/146569i6FBB70FCD12961E5/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000nSAfpAAG.png" alt="0695b00000nSAfpAAG.png" /></span></P><P>tFileOutputXML</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000nSAgOAAW.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144881iC81BF69CB6CD8FD3/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000nSAgOAAW.png" alt="0695b00000nSAgOAAW.png" /></span></P><P></P><P></P><P>tFileOutputXML Schema</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000nSAh2AAG.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/146570iB3F096A7F40C3D39/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000nSAh2AAG.png" alt="0695b00000nSAh2AAG.png" /></span></P><P></P><P></P><P>XML output</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000nSAhbAAG.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/148950iA21E8D7351AD4290/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000nSAhbAAG.png" alt="0695b00000nSAhbAAG.png" /></span></P> Fri, 15 Nov 2024 21:26:51 GMT Artemis_Mercury 2024-11-15T21:26:51Z https://community.qlik.com/t5/Talend-Studio/Combining-multiple-XML-into-one-using-the-same-schema/m-p/2357685#M122900 <P>Hello, </P><P></P><P></P><P>I'm currently facing a situation where I have several XML files that conform to a shared schema. However, each of these files holds data related to a distinct parent element within the schema. My goal is to merge these files into a unified tFileOutputXML, and I'm utilizing a tXMLMap for this task. Unfortunately, the result I'm getting seems to be duplicating the entire schema for each individual row of data that I input.</P><P></P><P></P><P>Could you kindly guide me on the steps to rectify this issue? I aim to generate a valid XML output that adheres accurately to the XSD Schema I imported. For additional clarity, I've attached some screenshots for your reference.</P><P></P><P></P><P>tXMLMap</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000nSAc7AAG.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134459i909B98A3FCB3AADA/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000nSAc7AAG.png" alt="0695b00000nSAc7AAG.png" /></span></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000nSAcRAAW.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144969i210663121278012E/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000nSAcRAAW.png" alt="0695b00000nSAcRAAW.png" /></span></P><P>tFileInputXML_1</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000nSAfBAAW.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/137326i4034689A462E7B1C/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000nSAfBAAW.png" alt="0695b00000nSAfBAAW.png" /></span></P><P></P><P></P><P>tFileInputXML_2</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000nSAfpAAG.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/146569i6FBB70FCD12961E5/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000nSAfpAAG.png" alt="0695b00000nSAfpAAG.png" /></span></P><P>tFileOutputXML</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000nSAgOAAW.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144881iC81BF69CB6CD8FD3/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000nSAgOAAW.png" alt="0695b00000nSAgOAAW.png" /></span></P><P></P><P></P><P>tFileOutputXML Schema</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000nSAh2AAG.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/146570iB3F096A7F40C3D39/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000nSAh2AAG.png" alt="0695b00000nSAh2AAG.png" /></span></P><P></P><P></P><P>XML output</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000nSAhbAAG.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/148950iA21E8D7351AD4290/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000nSAhbAAG.png" alt="0695b00000nSAhbAAG.png" /></span></P> Fri, 15 Nov 2024 21:26:51 GMT https://community.qlik.com/t5/Talend-Studio/Combining-multiple-XML-into-one-using-the-same-schema/m-p/2357685#M122900 Artemis_Mercury 2024-11-15T21:26:51Z