Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Nested loop in tAdvancedFileOutputXML

Can I have any nested loop in object tAdvancedFileOutputXML into "node status" ?
Labels (3)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I was able to achieve the multi level nested loop using tFileOutputMSXML, Thank you.

View solution in original post

9 Replies
Anonymous
Not applicable
Author

Thanks for all your help
Anonymous
Not applicable
Author

Hi there,
I'm a newbie in Talend, so I had to look around. From what I can see, you can't do that. It only accepts one loop element.
If you want to have multiple loops, you will have to use more advancedFileOutputXML components, one for each loop. To make sure that you write all the data, you have to put the component in append mode. Check the "Append the source xml file" checkbox in the advancedFileOuputXML properties. To copy the input flow to more components, use tReplicate.
I'm doing something similar right now. Tell me if you have other questions.
Anonymous
Not applicable
Author

It seems that when both advancedFileOutputXML are in the same subjob, the last element writes over the other ones even if the append mode is selected. To get the job done you have to put them in different subjobs and link them with onSubjobOk.
Normally, the write operations should be atomic, but it seems not. It seems that the output is not flushed to the file right away.
I think this might be a bug. Can you guys (the experts) confirm that this is normal behavior?
_AnonymousUser
Specialist III
Specialist III

Hi,
TOS/TIS doesn't manage nested loops. I just got this answer from the Talend support this week having the same problem.
Sorry.
Anonymous
Not applicable
Author

You can get multiple loops using tFileOutputMSXML.
Anonymous
Not applicable
Author

Hi,
I need to generate XML with Multiple level Nested Loop. Could anybody, assist on the same. How to Achive with tadvancedFileOutputXML or tFileOutputMSXML. I able to have only one Loop set using both these satges. Currently I am using Talend4.2.2, In any other higher version like 5 is it possible.
Anonymous
Not applicable
Author

i am having a problem...
i have 2 input rows....(1)for network element details...and(2) for card details.....i use a tmap because i need to map between values of these 2 schemas....actually, i need to create xlink:href......but I don't know how to craete that in talend!!!.....now i want to put all these in a single xml file....how can I do that???
Anonymous
Not applicable
Author

the problem is since i have used a tmap...,i have to have multiple rows coming from it for network element and card....now i am not able to combine it into a single tfileoutputmsxml
...does anybody have a solution for this??
Anonymous
Not applicable
Author

I was able to achieve the multi level nested loop using tFileOutputMSXML, Thank you.