Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

XML Mapping with multiple loop elements

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

 

Labels (3)
1 Reply
nfz11
Creator III
Creator III

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?