Creating XML with nested loop

Anonymous — Sat, 16 Nov 2024 10:40:48 GMT

Hi, I want to create xml structure for passing between job with nester loop.
Let's say my first input is:
<functions>
<function ID="bwl">B01</function>
</functions>

My second input looks like this:
<parameters>
<parameterSet functionRef="B01">
<parameter name="id">customer_A</parameter>
<parameter name="type">customer</parameter>
</parameterSet>
</parameters>

I desired output is this:
<function>
<name>bwl</name>
<ref>B01</ref>
<parameters>
<parameter name="id">customer_A</parameter>
<parameter name="type">customer</parameter>
</parameters>
</function>

The problem I have is with the <parameter> nodes. When I am trying to create nested loop for <parameter>, output is still 2x xml files with just one <parameter>, first one contains just <parameter name="id">customer_A</parameter>, second one <parameter name="type">customer</parameter>.

See screenshot to see my tXmlMap. I would appreciate any help. Thank you.

Re: Creating XML with nested loop

Anonymous — Fri, 29 Apr 2016 08:25:06 GMT

Hi
Check the 'all in one' parameter as true in the setting panel of output table. see

Regards
Shong

topic Re: Creating XML with nested loop in Talend Studio

Creating XML with nested loop

Re: Creating XML with nested loop