tXMLMap join of 3 tables problem

[Igor_V]

Hello community,

I have 3 tables:

ContactPerson  with 1 record

ContactPersonId ="Smith"

Document with 2 records ContactPersonId = "Smith"; DocumentId= "Doc1";

ContactPersonId = "Smith"; DocumentId = "Doc2";

Educations with 2 records ContactPersonId= "Smith"; EducationType = "First";

ContactPersonId = "Smith"; EducationType = "Second";

In TOS For ESB 7.4.1 in tXMLMap I join this 3 table as:

The result is:

<ContactPerson ContactPersonId="Smith">

<Document>

<DocId DocumentId="Doc1"/>

<DocId DocumentId="Doc1"/>

<DocId DocumentId="Doc2"/>

<DocId DocumentId="Doc2"/>

</Document>

<Education>

<EduType EducationType="First"/>

<EduType EducationType="Second"/>

<EduType EducationType="First"/>

<EduType EducationType="Second"/>

</Education>

</ContactPerson>

Data duplicates !

How can I generate the correct schema as?

<ContactPerson ContactPersonId="Smith">

<Document>

<DocId DocumentId="Doc1"/>

<DocId DocumentId="Doc1"/>

</Document>

<Education>

<EduType EducationType="First"/>

<EduType EducationType="Second"/>

</Education>

</ContactPerson>

I tried to change Lookup, Match and Join Models, but did not find the correct option.

[Anonymous]

@Grapeus Grapeus​ , It is a new feature request, the component need a group option while there are multiple loop elements. Some relevant issues have been open on Talend Bugtracker.

Regards

Shong