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

Loops in loop with tXmlMap or tFileOutputMSXML

Hi,
i need to have someting like this in out on my tXmlMap :
<Material>
<ID>1</ID>
<Description>testest</Description>
<Logistic>
<Property></Property>
</Logistic>
<Logistic>
<Property></Property>
</Logistic>
<Valuation
<Property></Property>
</Valuation>
<Valuation
<Property></Property>
</Valuation>
</Material>
<Material>
<ID>2</ID>
<Description>testest</Description>
<Logistic>
<Property></Property>
</Logistic>
<Logistic>
<Property></Property>
</Logistic>
<Valuation
<Property></Property>
</Valuation>
<Valuation
<Property></Property>
</Valuation>
</Material>
I can't set a loop with loops inside !
How can i do ?
Thank you.
(Talend Enterprise Studio 5.3.1)
Labels (3)
8 Replies
Anonymous
Not applicable
Author

Anyone have a solution ?
gfantone
Contributor
Contributor

Hello,
please gives the structure of the input stream.
Regards
Anonymous
Not applicable
Author

Please see screenshots below.
I need to add loop an the top object Material.
Thank you.
Anonymous
Not applicable
Author

tXmlMap can't made a complex structure like this.
I need a java code solution.
Someone has already merged xml documents ?
Thank you.
Anonymous
Not applicable
Author

I test it with a tFileOutputMSXML component but i haven't the result that i want.
I have the good result only in the first article, i want <Planning> in all article.
Please see scrennshots in attachment.
Thank you.
willm1
Creator
Creator

Hi Sylvain...
The tXMLMap component will let you 'group' child nodes then loop on lower nodes - on the output side of the component. See attached screenshot from https://help.talend.com/search/all?query=tXMLMap+operation&content-lang=en
If that does not do it with the tXMLMap, take a look at this - http://www.talendforge.org/forum/viewtopic.php?pid=129892#p129892
Anonymous
Not applicable
Author

Hi willm,
It doesn't work with tXmlMap because i need to have multiple loops under group node.
The tXmlMap component can just have one loop under a group node Smiley Sad !
I've seen this post but it doesn't work in my case.
Thank you
Anonymous
Not applicable
Author

Did you get any solution to your problem? I am facing the same problem