topic Re: [resolved] How to read recursive XML tags in Talend Studio

[resolved] How to read recursive XML tags

fyk_cz — Sat, 16 Nov 2024 13:26:06 GMT

Hi all,
i have a some XML like this:

<tasks>
  <task id="1" name="Task1">
    <task id="11" name="Task11" />
    <task id="12" name="Task12" />
  </task>
  <task id="2" name="Task2" >
    <task id="21" name="Task21"/>
  </task>
</tasks>

and I need flat rows ID, Name from each task tag. How to define Loop XPath query for tFileInputXML component?

Re: [resolved] How to read recursive XML tags

Anonymous — Wed, 12 May 2010 15:55:46 GMT

Loop xpath query should be : //task
it will retrieve all task element in the file
for column id xpath query would be : ./@id

Re: [resolved] How to read recursive XML tags

fyk_cz — Thu, 13 May 2010 08:00:30 GMT

YES!!! ... That's it. Thx vm.

Re: [resolved] How to read recursive XML tags

Anonymous — Tue, 13 Jul 2010 10:13:01 GMT

<?xml version="1.0" encoding="ISO-8859-1"?>
<bookstore>
<book category="COOKING">
<title lang="en">Everyday Italian</title>
<author>Giada De Laurentiis</author>
<year>2005</year>
<price>30.00</price>
</book>
<book category="CHILDREN">
<title lang="en">Harry Potter</title>
<author>J K. Rowling</author>
<year>2005</year>
<price>29.99</price>
</book>
</bookstore>

This is my xml file and when i am reading this file i am only getting output 2 time but the same value as the first row printed twice
my loopxpath query is /bookstore/book

Re: [resolved] How to read recursive XML tags

Anonymous — Tue, 13 Jul 2010 10:14:10 GMT

So can anyoen help to resolve this bug

Re: [resolved] How to read recursive XML tags

Anonymous — Wed, 14 Jul 2010 10:40:33 GMT

I have been breaking my head with the same problem

Re: [resolved] How to read recursive XML tags

Anonymous — Wed, 14 Jul 2010 21:19:35 GMT

Hi,
Make sure there is not a UTF-8 signature (BOM) on the XML file which can cause weird behavior in Talend.
See http://www.w3.org/International/questions/qa-utf8-bom for additional information.
Best,
-Randall