Append XML elements to XML file based on several input rows

Anonymous — Thu, 03 Apr 2014 10:34:20 GMT

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>

Re: Append XML elements to XML file based on several input rows

willm1 — Thu, 03 Apr 2014 15:42:09 GMT

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

topic Re: Append XML elements to XML file based on several input rows in Talend Studio

Append XML elements to XML file based on several input rows

Re: Append XML elements to XML file based on several input rows