Loops in loop with tXmlMap or tFileOutputMSXML

One Star

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)
One Star

Re: Loops in loop with tXmlMap or tFileOutputMSXML

Anyone have a solution ?
One Star

Re: Loops in loop with tXmlMap or tFileOutputMSXML

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

Re: Loops in loop with tXmlMap or tFileOutputMSXML

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

Re: Loops in loop with tXmlMap or tFileOutputMSXML

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

Re: Loops in loop with tXmlMap or tFileOutputMSXML

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

Re: Loops in loop with tXmlMap or tFileOutputMSXML

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
One Star

Re: Loops in loop with tXmlMap or tFileOutputMSXML

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
Four Stars

Re: Loops in loop with tXmlMap or tFileOutputMSXML

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