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

    XML: Load multiple tables in one go

    Ronny Waage

      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?