topic Re: How to create XML with multiple loop in Talend Studio

How to create XML with multiple loop

Anonymous — Sun, 11 Feb 2018 08:29:59 GMT

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.

Re: How to create XML with multiple loop

Anonymous — Sun, 11 Feb 2018 22:20:31 GMT

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

Re: How to create XML with multiple loop

Anonymous — Mon, 12 Feb 2018 19:30:00 GMT

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

Re: How to create XML with multiple loop

Anonymous — Fri, 20 Apr 2018 02:24:30 GMT

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

Re: How to create XML with multiple loop

Anonymous — Tue, 08 Jan 2019 09:35:51 GMT

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