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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with interpreting XML data

My project accounting system allows exporting data into the following xml format only:
- <response>
- <id3812665>
<id>3812665</id>
<title>x</title>
<created>2010-07-14T06:34:23+00:00</created>
<viewed>2010-09-19T09:33:16+00:00</viewed>
<updated>2010-09-17T13:03:40+00:00</updated>
</id3812665>
- <id4297786>
<id>4297786</id>
<title>y</title>
<created>2010-08-02T06:31:56+00:00</created>
<viewed>2010-09-19T09:33:16+00:00</viewed>
<updated>2010-09-15T18:22:19+00:00</updated>
</id4297786>
...
<count>1001</count>
<status>success</status>
</response>
I want to load the xml data into my QV application. However, as instead of simple tag <project> the xml file has a separate tag for each project (like <id3812665>, <id4297786>, etc.), the standard xml data load wizard in QV gives out the following load script:
LOAD
[id3812665/id],
[id3812665/title],
[id3812665/created],
[id3812665/viewed],
[id3812665/updated],
[id4297786/id],
[id4297786/title],
[id4297786/created],
[id4297786/viewed],
[id4297786/updated],
..
count,
status
FROM ..\projectblogs.xml (XmlSimple, Table is [response]);
Question: How can I define the load script to have all actual project values (id, title, created, viewed, updated) concatenated into one simple table? (taking into account that there are hundreds of projects whose total number is quickly increasing and range of possible project IDs is in millions)

0 Replies