Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

ronnywaage
New Contributor III

XML: Load multiple tables in one go

Hi

I am loading data from an XML file available on a web page.

My_Table1:
LOAD val_1,
    val_2,
    %Key_entite_DFC2BCF3243EB63E as KEY_ENTITE   // Key to parent table: export/entite
FROM [http://www....?startDate=2015-01-01&endDate=2015-03-31] (XmlSimple, Table is [my_table1]);

This works ok. The issue is that it takes some time to download this xml file. And since I am fetching two tables from the same xml I have to  (with my limited qlikview-knowledge) to send the request twice to the data provider.

My_Table2:

...

FROM [http://www....?startDate=2015-01-01&endDate=2015-03-31] (XmlSimple, Table is [my_table2]);

Is there a smart way to get both table 1 and 2 in one go, so I don't have to send the request for data twice to the data provider?

Community Browser