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: 
Anonymous
Not applicable

Append XML elements to XML file based on several input rows

I would like to create the following XML file based on input values. The input is simulated by tFixedFlowInput in the attached job:
<?xml version="1.0" encoding="ISO-8859-15"?>
<test>
<testsub testattr="89">
<testsubsub>59</testsubsub>
</testsub>
<testsub testattr="47">
<testsubsub>86</testsubsub>
</testsub>
</test>
But unfortunately the result looks as follows:
<?xml version="1.0" encoding="ISO-8859-15"?>
<test>
<testsub testattr="89">
<testsubsub>59</testsubsub>
</testsub>
</test>
<?xml version="1.0" encoding="ISO-8859-15"?>
<test>
<testsub testattr="47">
<testsubsub>86</testsubsub>
</testsub>
</test>
0683p000009MDY8.png 0683p000009MDQP.png 0683p000009MDO8.png
Labels (3)
1 Reply
willm1
Creator
Creator

ohofrichter - I tried to replicate your issue and unchecked the "Remove the XML declaration" on tWriteXMLField. That didn't work - I was expecting it to remove the declaration lines between the rows...
I know that tXMLMap allows you to write only 1 xml declaration per file, regardless of how many rows you have... But that's no help with your current design...