topic Re: @@@@ NEED HELP @@@ tFileOutputMSXML in Talend Studio

@@@@ NEED HELP @@@ tFileOutputMSXML

_AnonymousUser — Thu, 10 Sep 2015 06:19:00 GMT

[font=Calibri, sans-serif]We need some urgent help from you. We have a requirement to create an XML file with multiple looping elements. Only component that we found can achieve multiple looping/ grouping in Talend is tFileOutputMSXML component. We are facing a huge challenge with this component. If number of records are low, the component works fine. But if number of input records are 100K + performance is horrible and it keeps deteriorating with each new records read. [/font]

Re: @@@@ NEED HELP @@@ tFileOutputMSXML

Anonymous — Thu, 10 Sep 2015 17:08:12 GMT

Multiple nested loops are not supported in the core component. You need Talend Data Mapper part of the Talend Platform products.
Thomas

Re: @@@@ NEED HELP @@@ tFileOutputMSXML

Anonymous — Fri, 08 Jul 2016 10:07:03 GMT

tsteinborn wrote:
Multiple nested loops are not supported in the core component. You need Talend Data Mapper part of the Talend Platform products.
Thomas

hi Tomas
Below is my tXMLMap and the desired XML file in output, items "memberType" and "trading" are loop elements. My problem is that I can't fix "role", "memberTypes" and "tradings" as group element, to get the xml output file (attached bellow).

thx for help.

Re: @@@@ NEED HELP @@@ tFileOutputMSXML

Anonymous — Sun, 10 Jul 2016 10:03:36 GMT

Hi, which part of the statement "Multiple nested loops are not supported in the core component" could not be understood?
At the moment, a solution to build really complex XML documents outside the Platform editions of Talend is using tJavaFlex with dom4j API.
Another way - perhaps the better way - is using JAX-B annotated classes (made in a separate Java project and included as library in your job).

The performance problems are well known and are caused by the dom approach of the mentioned component. We prefer to build smaller xml files and chaining them to huge xml files in a separate job.