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)