Four Stars pn
Four Stars

How to create XML with multiple loop

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Fifteen Stars

Re: How to create XML with multiple loop

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://www.talendforge.org/forum/viewtopic.php?id=54784

 

Rilhia Solutions
3 REPLIES
Fifteen Stars

Re: How to create XML with multiple loop

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://www.talendforge.org/forum/viewtopic.php?id=54784

 

Rilhia Solutions
Four Stars pn
Four Stars

Re: How to create XML with multiple loop

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

Re: How to create XML with multiple loop

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