tXMLMap join of 3 tables problem

Igor_V — Fri, 04 Jun 2021 12:17:25 GMT

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:

</Document>

</Education>

</ContactPerson>

Data duplicates !

How can I generate the correct schema as?

</Document>

</Education>

</ContactPerson>

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

Re: tXMLMap join of 3 tables problem

Anonymous — Mon, 05 Jul 2021 08:50:14 GMT

@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

topic tXMLMap join of 3 tables problem in Talend Studio

tXMLMap join of 3 tables problem

Re: tXMLMap join of 3 tables problem