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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

@@@@ NEED HELP @@@ tFileOutputMSXML

[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]

Labels (2)
3 Replies
Anonymous
Not applicable

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

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).

0683p000009MGb0.jpg     0683p000009MGhH.jpg
    

thx for help.
Anonymous
Not applicable

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.