Grouping a multiple xml tags from different elements into the same element

[Anonymous]

Hello everyone, 

I need some help regarding an xml problem : 

I have the following file : 

<father>
    <primary>875539032</primary>
    <version>1</version>
    <creationTime>2018-05-17</creationTime>
    <name>NY</name>
    <id>11A12</id>
    <id>12A13</id>
    <id>13A14</id>
    <other>39xA0</other>
</father>
<father>
    <primary>875539032</primary>
    <version>1</version>
    <creationTime>2018-05-17</creationTime>
    <name>NY</name>
    <id>11A12</id>
    <id>12A13</id>
    <id>13A14</id>
    <other>39xA4</other>
</father>
<father>
    <primary>875539032</primary>
    <version>1</version>
    <creationTime>2018-05-17</creationTime>
    <name>NY</name>
    <id>11A12</id>
    <id>12A13</id>
    <id>13A14</id>
    <other>39xA7</other>
</father>

I want to group all the <other> in the same <father> because they have the same primary key <primary>

I tried to use a tXMLMap but didn't work and lost the tags <id>, it seems i can't loop on 2 elements correctly so maybe my components configuration is not OK, or maybe i don't use the right component..

Can someone help me please ?

Regards,

MBD

[manodwhb]

@Maro11,did you looked into below link?

https://help.talend.com/reader/ixBASPZJ7IvqUQVupZwWbg/EFuE5Nul595D24TRwbFnbw