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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2019-11-27 03:59 AM

export data from xml to csv

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.

Labels (2)
Labels
426 Views
0 Likes
6 Replies
Anonymous
Not applicable
‎2019-11-27 04:05 AM
Author

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

Regards
Shong
426 Views
0 Likes
Anonymous
Not applicable
‎2019-11-27 04:11 AM
Author

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


Capture.PNG
426 Views
0 Likes
Anonymous
Not applicable
‎2019-11-27 04:15 AM
Author

Would you mind uploading the sample file for testing?
426 Views
0 Likes
Anonymous
Not applicable
‎2019-11-27 04:19 AM
Author

Of course!!


out.xml
426 Views
0 Likes
Anonymous
Not applicable
‎2019-11-27 05:51 AM
Author

Hi,

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

Reagrds

Guru

426 Views
0 Likes
Anonymous
Not applicable
‎2019-11-27 06:30 AM
Author

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

426 Views
0 Likes