topic Re: XML with nested Loops, any idea ? in Talend Studio

XML with nested Loops, any idea ?

Anonymous — Sat, 07 Nov 2015 22:30:02 GMT

Folks,

I have a question for ya talend cracks.
Its quite easy.

Given a very simle DataModel, maybe in Access:

I want to create this nested XML:

It is no Problem to use tFileOutputMsXML:

Attached you find zipped: Data, project.zip and *.xsd:

NestedLoops.rar

But the disadvantage of this component - it creates only files, so using with REST/ESB needs ugly Workaround.

Has any one a solution with tXmlMap or any other components creating document as stream (not as file) ?

Any ideas ?

Re: XML with nested Loops, any idea ?

Anonymous — Mon, 16 Nov 2015 08:51:31 GMT

It is impossible to generate this document on tXMLMap, you can read the file as a document with tFileInputXML after you generate the XML file with tFileOutputMSXML, see

Re: XML with nested Loops, any idea ?

Anonymous — Mon, 16 Nov 2015 16:13:28 GMT

Shong, thanks for your Response ...
If Workaround with fixed file Name ... i get an Problem with concurrency ? (Next call writes same File-Name, prev call reads) in ESB Environment ?

Re: XML with nested Loops, any idea ?

Anonymous — Tue, 17 Nov 2015 07:55:59 GMT

You are right, it may cause conflict to read the same file if many calls at the same time, it is better to define a dynamic file name, for example, define the file name with current datetime in the beginning of job on a tJava:
context.filename=formatDate("yyyyMMddHH:mm:ss",TalendDate.getCurrentDate())+".xml";

It will generates a file name like 20151116121511.xml

and delete the file in the end of job if needed.

Re: XML with nested Loops, any idea ?

Anonymous — Fri, 20 Nov 2015 21:45:02 GMT

This is what we call "an ugly Workaround"