topic Re: export data from xml to csv in Talend Studio

export data from xml to csv

Anonymous — Wed, 27 Nov 2019 08:59:27 GMT

Hello, I have a problem with my xml file.
the file is the result of a "GET" and it looks like this one.
The problem I have is the "<int> </int>, <string> subtags that I have under the <field>" tags and I can't get the information I want. if someone has an idea. Thank you. Thank you.

Re: export data from xml to csv

Anonymous — Wed, 27 Nov 2019 09:05:18 GMT

Hi
Set the xpath loop element to Field, rather than Fields.

Regards
Shong

Re: export data from xml to csv

Anonymous — Wed, 27 Nov 2019 09:11:46 GMT

it doesn't change anything. I think the problem is that my subtags are predefined types "<int> <string>"

Capture.PNG

Re: export data from xml to csv

Anonymous — Wed, 27 Nov 2019 09:15:25 GMT

Would you mind uploading the sample file for testing?

Re: export data from xml to csv

Anonymous — Wed, 27 Nov 2019 09:19:58 GMT

Of course!!

out.xml

Re: export data from xml to csv

Anonymous — Wed, 27 Nov 2019 10:51:26 GMT

Hi,

What's the output you are expecting in this file.

Reagrds

Guru

Re: export data from xml to csv

Anonymous — Wed, 27 Nov 2019 11:30:10 GMT

retrieve all values that are between the tags "<int>, <string> and <dateTime>"