topic Re: How can I create a xml file with loop some tag? in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 04:44:36 GMT

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

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

Anonymous — Sun, 08 Sep 2019 13:51:33 GMT

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

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

Anonymous — Mon, 09 Sep 2019 07:27:58 GMT

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

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

Anonymous — Mon, 09 Sep 2019 07:49:26 GMT

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.

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

Anonymous — Tue, 10 Sep 2019 03:04:06 GMT

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.

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

Anonymous — Tue, 10 Sep 2019 06:20:27 GMT

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.

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

Anonymous — Thu, 12 Sep 2019 12:23:36 GMT

Is there anyone who would help me about this subject?