How to create XML with multiple loop

[Anonymous]

hi,

How can I build a XML with multiple loop elements , I have tried with tAdvancedFileOutputXML but it doesn't support more than 1 loop element.

PFA an attached XML, I have multiple customers in a single XML and each customer has multiple Address and payment type information. How can I achieve this using Talend component.

BTW my input data is from a Database.

I have to build this job in Free TOS edition only (using TOS V6.4.1 )

Any help will be appreciated.

[Anonymous · Accepted solution]

You can do this with Talend's Enterprise Edition (or Data Fabric) using the Talend Data Mapper. Unfortunately, that doesn't appear to be an option for you. But there is another way. You can build your XML in sections and then "glue" it together. I describe this in this post in the old Talend forum.... https://community.talend.com/t5/Design-and-Development/Multiple-Nested-loop-in-outputXML/td-p/82289

[Anonymous]

Thanks, I will follow the link and try to implement that way.

[Anonymous]

Hi,

Can you explain the solution on how you solved it? we are facing similar issue and want to know how to implement it?

Thanks

Lokanath

[Anonymous]

Hi, there,

I have a nested XML structure like:

<?xml version="1.0" encoding="UTF-8"?>
<Account>
<name>AccountXML1</name>
<phone>123456</phone>
<Contact>
<lastname>Book1</lastname>
<department>EN</department>
</Contact>
<Contact>
<lastname>Book2</lastname>
<department>FR</department>
</Contact>
</Account>

I want to extract data as:

Account-

Name,Phone

AccountXML1,123456

Contact-

LastName,Department

Book1,EN

Book2,FR

How can I do it in Talend? I have tried with tFileInputMSXML but unable to understand how to provide multiple XPath queries

Hierarchy Scenario1.xml