XML: Load multiple tables in one go

Ask a Question

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?

0 Replies