0 Replies Latest reply: Apr 25, 2014 6:12 AM by Ronny Waage RSS

    XML: Load multiple tables in one go

    Ronny Waage



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


      LOAD val_1,
          %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.




      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?