https://community.qlik.com/t5/Talend-Studio/AGGREGAT-XML-OUTPUT/m-p/2296158#M68853 <P>Hi,</P> <P>I generate an output XML file, and a sery of bloc looks like bellow</P> <PRE>&lt;StopArea&gt; &lt;objectId&gt;BUSVERT:StopArea:76660&lt;/objectId&gt; &lt;objectVersion&gt;1&lt;/objectVersion&gt; &lt;creationTime&gt;2018-04-25T13:48:17&lt;/creationTime&gt; &lt;name&gt;SANDOUVILLE &lt;/name&gt; &lt;contains&gt;BUSVERT:StopPoint:12&lt;/contains&gt; &lt;centroidOfArea&gt;BUSVERT:AreaCentroid:76660&lt;/centroidOfArea&gt; &lt;StopAreaExtension&gt; &lt;areaType&gt;CommercialStopPoint&lt;/areaType&gt; &lt;fareCode&gt;13&lt;/fareCode&gt; &lt;registration&gt; &lt;registrationNumber&gt;76660&lt;/registrationNumber&gt; &lt;/registration&gt; &lt;/StopAreaExtension&gt; &lt;/StopArea&gt; &lt;StopArea&gt; &lt;objectId&gt;BUSVERT:StopArea:76660&lt;/objectId&gt; &lt;objectVersion&gt;1&lt;/objectVersion&gt; &lt;creationTime&gt;2018-04-25T13:48:17&lt;/creationTime&gt; &lt;name&gt;SANDOUVILLE &lt;/name&gt; &lt;contains&gt;BUSVERT:StopPoint:22&lt;/contains&gt; &lt;centroidOfArea&gt;BUSVERT:AreaCentroid:76660&lt;/centroidOfArea&gt; &lt;StopAreaExtension&gt; &lt;areaType&gt;CommercialStopPoint&lt;/areaType&gt; &lt;fareCode&gt;13&lt;/fareCode&gt; &lt;registration&gt; &lt;registrationNumber&gt;76660&lt;/registrationNumber&gt; &lt;/registration&gt; &lt;/StopAreaExtension&gt; &lt;/StopArea&gt;</PRE> <P>You can note that all data have the same only data of&nbsp;<STRONG>contains</STRONG> tag</P> <P>So my focus is top aggrege output to have this exemple&nbsp;</P> <PRE>&lt;StopArea&gt; &lt;objectId&gt;BUSVERT:StopArea:76660&lt;/objectId&gt; &lt;objectVersion&gt;1&lt;/objectVersion&gt; &lt;creationTime&gt;2018-04-25T13:48:17&lt;/creationTime&gt; &lt;name&gt;SANDOUVILLE &lt;/name&gt; &lt;contains&gt;BUSVERT:StopPoint:12&lt;/contains&gt; &lt;contains&gt;BUSVERT:StopPoint:22&lt;/contains&gt; &lt;centroidOfArea&gt;BUSVERT:AreaCentroid:76660&lt;/centroidOfArea&gt; &lt;StopAreaExtension&gt; &lt;areaType&gt;CommercialStopPoint&lt;/areaType&gt; &lt;fareCode&gt;13&lt;/fareCode&gt; &lt;registration&gt; &lt;registrationNumber&gt;76660&lt;/registrationNumber&gt; &lt;/registration&gt; &lt;/StopAreaExtension&gt; &lt;/StopArea&gt;</PRE> <P>Thank you for help,</P> Sat, 16 Nov 2024 08:20:53 GMT idembel2 2024-11-16T08:20:53Z https://community.qlik.com/t5/Talend-Studio/AGGREGAT-XML-OUTPUT/m-p/2296158#M68853 <P>Hi,</P> <P>I generate an output XML file, and a sery of bloc looks like bellow</P> <PRE>&lt;StopArea&gt; &lt;objectId&gt;BUSVERT:StopArea:76660&lt;/objectId&gt; &lt;objectVersion&gt;1&lt;/objectVersion&gt; &lt;creationTime&gt;2018-04-25T13:48:17&lt;/creationTime&gt; &lt;name&gt;SANDOUVILLE &lt;/name&gt; &lt;contains&gt;BUSVERT:StopPoint:12&lt;/contains&gt; &lt;centroidOfArea&gt;BUSVERT:AreaCentroid:76660&lt;/centroidOfArea&gt; &lt;StopAreaExtension&gt; &lt;areaType&gt;CommercialStopPoint&lt;/areaType&gt; &lt;fareCode&gt;13&lt;/fareCode&gt; &lt;registration&gt; &lt;registrationNumber&gt;76660&lt;/registrationNumber&gt; &lt;/registration&gt; &lt;/StopAreaExtension&gt; &lt;/StopArea&gt; &lt;StopArea&gt; &lt;objectId&gt;BUSVERT:StopArea:76660&lt;/objectId&gt; &lt;objectVersion&gt;1&lt;/objectVersion&gt; &lt;creationTime&gt;2018-04-25T13:48:17&lt;/creationTime&gt; &lt;name&gt;SANDOUVILLE &lt;/name&gt; &lt;contains&gt;BUSVERT:StopPoint:22&lt;/contains&gt; &lt;centroidOfArea&gt;BUSVERT:AreaCentroid:76660&lt;/centroidOfArea&gt; &lt;StopAreaExtension&gt; &lt;areaType&gt;CommercialStopPoint&lt;/areaType&gt; &lt;fareCode&gt;13&lt;/fareCode&gt; &lt;registration&gt; &lt;registrationNumber&gt;76660&lt;/registrationNumber&gt; &lt;/registration&gt; &lt;/StopAreaExtension&gt; &lt;/StopArea&gt;</PRE> <P>You can note that all data have the same only data of&nbsp;<STRONG>contains</STRONG> tag</P> <P>So my focus is top aggrege output to have this exemple&nbsp;</P> <PRE>&lt;StopArea&gt; &lt;objectId&gt;BUSVERT:StopArea:76660&lt;/objectId&gt; &lt;objectVersion&gt;1&lt;/objectVersion&gt; &lt;creationTime&gt;2018-04-25T13:48:17&lt;/creationTime&gt; &lt;name&gt;SANDOUVILLE &lt;/name&gt; &lt;contains&gt;BUSVERT:StopPoint:12&lt;/contains&gt; &lt;contains&gt;BUSVERT:StopPoint:22&lt;/contains&gt; &lt;centroidOfArea&gt;BUSVERT:AreaCentroid:76660&lt;/centroidOfArea&gt; &lt;StopAreaExtension&gt; &lt;areaType&gt;CommercialStopPoint&lt;/areaType&gt; &lt;fareCode&gt;13&lt;/fareCode&gt; &lt;registration&gt; &lt;registrationNumber&gt;76660&lt;/registrationNumber&gt; &lt;/registration&gt; &lt;/StopAreaExtension&gt; &lt;/StopArea&gt;</PRE> <P>Thank you for help,</P> Sat, 16 Nov 2024 08:20:53 GMT https://community.qlik.com/t5/Talend-Studio/AGGREGAT-XML-OUTPUT/m-p/2296158#M68853 idembel2 2024-11-16T08:20:53Z