AGGREGAT XML OUTPUT

Seven Stars

AGGREGAT XML OUTPUT

Hi,

I generate an output XML file, and a sery of bloc looks like bellow

<StopArea>
  <objectId>BUSVERT:StopArea:76660</objectId>
  <objectVersion>1</objectVersion>
  <creationTime>2018-04-25T13:48:17</creationTime>
  <name>SANDOUVILLE </name>
  <contains>BUSVERT:StopPoint:12</contains>
  <centroidOfArea>BUSVERT:AreaCentroid:76660</centroidOfArea>
  <StopAreaExtension>
    <areaType>CommercialStopPoint</areaType>
    <fareCode>13</fareCode>
    <registration>
      <registrationNumber>76660</registrationNumber>
    </registration>
  </StopAreaExtension>
</StopArea>

<StopArea>
  <objectId>BUSVERT:StopArea:76660</objectId>
  <objectVersion>1</objectVersion>
  <creationTime>2018-04-25T13:48:17</creationTime>
  <name>SANDOUVILLE </name>
  <contains>BUSVERT:StopPoint:22</contains>
  <centroidOfArea>BUSVERT:AreaCentroid:76660</centroidOfArea>
  <StopAreaExtension>
    <areaType>CommercialStopPoint</areaType>
    <fareCode>13</fareCode>
    <registration>
      <registrationNumber>76660</registrationNumber>
    </registration>
  </StopAreaExtension>
</StopArea>

You can note that all data have the same only data of contains tag

So my focus is top aggrege output to have this exemple 

<StopArea>
  <objectId>BUSVERT:StopArea:76660</objectId>
  <objectVersion>1</objectVersion>
  <creationTime>2018-04-25T13:48:17</creationTime>
  <name>SANDOUVILLE </name>
  <contains>BUSVERT:StopPoint:12</contains>
  <contains>BUSVERT:StopPoint:22</contains>
  <centroidOfArea>BUSVERT:AreaCentroid:76660</centroidOfArea>
  <StopAreaExtension>
    <areaType>CommercialStopPoint</areaType>
    <fareCode>13</fareCode>
    <registration>
      <registrationNumber>76660</registrationNumber>
    </registration>
  </StopAreaExtension>
</StopArea>

Thank you for help,

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.