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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How can I create a xml file with loop some tag?

I need to create a xml file with loop some tag while a value of a variable is the same. When the value of a variable change i stop the loop and i continue. This follow is a file I created attached fileExample.xml

 

 

My developpement is the following :job attached file

 

Labels (4)
6 Replies
Anonymous
Not applicable
Author

Hi
nomenclature should be set as a loop element, can you upload a screenshot of XML tree structure on tAdvancedFileOutputXML?

Anonymous
Not applicable
Author

I have made nomenclature as Loop but it doesn't make loop because i need to make a condition for this loop. How can I do that? I want loop only if the condition 1:table1.columnA equals table2.columnA I'm looking for exit if the loop if condition1 isn't verify. It's very difficult to make that.

In short if condition1 verify i'm looking for all line from table3.columnB when table2.columnB = table3.columnB

 


XMLTree.PNG
Anonymous
Not applicable
Author

J'ai vraiment besoin d'aide en urgence car cela fait 7 jours que je travaille dessus sans succès et je suis débutant. Merci à ceux qui pourront m'aider.

Anonymous
Not applicable
Author

It sounds like you just want to have the data in the xml file only when table1.columnA equals table2.columnA and table2.columnB = table3.columnB, if this is the case, you can do inner joins to filter the rows.

Anonymous
Not applicable
Author

No i want just organize the rows from tables put in the order not just to keep only rows selected by inner filter. Make in the order the rows but with condition.

Anonymous
Not applicable
Author

Is there anyone who would help me about this subject?