XML with nested Loops, any idea ?

[Anonymous]

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 ?

[Anonymous]

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

[Anonymous]

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 ?

[Anonymous]

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. 

[Anonymous]

This is what we call "an ugly Workaround"