Problem with interpreting XML data

Tue, 21 Sep 2010 10:35:20 GMT

My project accounting system allows exporting data into the following xml format only:

- <response>

- <id3812665>

</id3812665>

- <id4297786>

</id4297786>

...

<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)

topic Problem with interpreting XML data in QlikView

Problem with interpreting XML data