load XML file as a whole - not as seperated tables

wizardo — Thu, 26 Apr 2018 08:36:47 GMT

hello,

i am reading some XML that is generated as response from a web-service.

this XML structure contains 2 tables.

when i use the QV xml wizard it splits the load into 2 separate loads with a joining keyfield

usually i don't have a problem with this behavior but in a certain case i do have a problem:)

the thing is that this way of reading causes the QV to actually send the request to the web-service as two separated(identical) queries, one right after the other. (i assume it then goes and parse the corresponding table each time)

the problem is that since i have to run the load in a loop (since i can only get max of 1000 rows each time)

this means that for each iteration QV sends the request twice.

this is aproblem with the supplier who owns the web-service.

when i use the same URL in excel for example i get the entire XML as response (without parsing)

is there a way to read the xml from the web-service as a whole file and save it and then i will read the file using the QV XML wizard.

hope i made my self clear.

thanks

Daniel Chotzen

Re: load XML file as a whole - not as seperated tables

Gysbert_Wassenaar — Thu, 26 Apr 2018 08:53:59 GMT

Try loading it as text:

MyXMLFile:

LOAD

@1 as Line

FROM

http://somewhere/myxml.xml (txt)

;

STORE MyXMLFile into ;

topic Re: load XML file as a whole - not as seperated tables in QlikView

load XML file as a whole - not as seperated tables

Re: load XML file as a whole - not as seperated tables