3 Replies Latest reply: Dec 2, 2014 5:18 AM by Gysbert Wassenaar RSS

    XML load into QlikView

      Goodmorning,

       

      I have to load about XML files into QlikView.

      But QlikView seems to make different rows within the same XML file.
      I'd like to have all the information within one row instead of 3 rows (in this example)

       

      The XML file and the output of the table are attached.

      A part of the script is written below :

      Lineitem:
      Load FileName() as %Filename
      [Customer/CustomerID],
      [Sales/Quantity],
      [Return/Returnreason]
      From datacol*.xml (XMLsimple, Table is ([Transaction/RetailTransaction/LineItem]);
      store LineItem into LineItem.qvd;
      

       

       

       

       

      Hope someone can advice me.

       

      Regards,

      Liselotte