topic Loops in loop with tXmlMap or tFileOutputMSXML in Talend Studio

Loops in loop with tXmlMap or tFileOutputMSXML

Anonymous — Mon, 10 Feb 2014 16:44:25 GMT

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)

Re: Loops in loop with tXmlMap or tFileOutputMSXML

Anonymous — Wed, 12 Feb 2014 14:42:08 GMT

Anyone have a solution ?

Re: Loops in loop with tXmlMap or tFileOutputMSXML

gfantone — Wed, 12 Feb 2014 15:37:07 GMT

Hello,
please gives the structure of the input stream.
Regards

Re: Loops in loop with tXmlMap or tFileOutputMSXML

Anonymous — Wed, 12 Feb 2014 15:50:25 GMT

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

Re: Loops in loop with tXmlMap or tFileOutputMSXML

Anonymous — Thu, 27 Mar 2014 10:07:45 GMT

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

Re: Loops in loop with tXmlMap or tFileOutputMSXML

Anonymous — Thu, 27 Mar 2014 15:49:18 GMT

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.

Re: Loops in loop with tXmlMap or tFileOutputMSXML

willm1 — Thu, 27 Mar 2014 18:44:04 GMT

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

Re: Loops in loop with tXmlMap or tFileOutputMSXML

Anonymous — Fri, 28 Mar 2014 08:19:48 GMT

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 !
I've seen this post but it doesn't work in my case.
Thank you

Re: Loops in loop with tXmlMap or tFileOutputMSXML

Anonymous — Wed, 19 Sep 2018 16:12:22 GMT

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