topic Re: tExtractXMLField returns same firstname instead of moving to next firstname tag in Talend Studio

tExtractXMLField returns same firstname instead of moving to next firstname tag

Cherichoc- — Fri, 15 Nov 2024 23:05:15 GMT

I have an the below xml file . My job is tFileInputXML--->tExtractXMLField--->tlog

My tExtractXMLField is set as the below. It keeps returning the Only the first firstname for all the other rows instead of the expected results. How can I set it to return only

<root><status>success</status>

</book>

</book>

</users>

<users><firstname>Abdul</firstname>

<book><name>SeeSaw</name>

</book>

</book>

</users>

</data>

</root>

Re: tExtractXMLField returns same firstname instead of moving to next firstname tag

Anonymous — Sat, 26 Mar 2022 00:35:14 GMT

Can you show your full tExtractXMLField configuration please?

Re: tExtractXMLField returns same firstname instead of moving to next firstname tag

Cherichoc- — Sat, 26 Mar 2022 01:03:51 GMT

Re: tExtractXMLField returns same firstname instead of moving to next firstname tag

Anonymous — Sat, 26 Mar 2022 01:15:34 GMT

Change firstname to ....

"../firstname"

Re: tExtractXMLField returns same firstname instead of moving to next firstname tag

Cherichoc- — Sat, 26 Mar 2022 01:24:24 GMT

Thank you, it worked. I definitely need to learn more about xPath 🙂