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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Creating XML with nested loop

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.

0683p000009MH9O.png
Labels (3)
1 Reply
Anonymous
Not applicable
Author

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

0683p000009MH1P.png

Regards
Shong