XML Mapping with multiple loop elements

Anonymous — Wed, 24 Apr 2019 14:56:47 GMT

Hi,

I'm using the Talend Open Studio for Data Integration (v.7.1.1.20181026_1147) and I'm trying to merge two xml files into another xml file. In attach i send to you both those files, with the name "tabela1.xml" and "tabela2.xml" respectively. The desired output is also in attach with the name "result.xml" as the project itself (MERGEXML.zip).

At this stage i'm not able to get the output I want, because I can't figure out how to add two loop elements (see image capture.png in attach).

Can you please advice me how to accomplish this?

Thanks in advance,

Best regards,

Pedro

Re: XML Mapping with multiple loop elements

nfz11 — Sun, 05 May 2019 00:39:53 GMT

In the results you want this:

...
	<person>
		<id>2</id>
		<name>Francisca</name>
		<age>34</age>
                <cars>
          		<brand>Fiat</brand>
	        	<brand>VW</brand>
                </cars>
	</person>
...

not this

...
	<person>
		<id>2</id>
		<name>Francisca</name>
		<age>34</age>
		<brand>Fiat</brand>
		<brand>VW</brand>
	</person>
...

Right?

topic XML Mapping with multiple loop elements in Talend Studio

XML Mapping with multiple loop elements

Re: XML Mapping with multiple loop elements