topic XML load into QlikView in QlikView

XML load into QlikView

Fri, 28 Nov 2014 08:43:45 GMT

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

Re: XML load into QlikView

Gysbert_Wassenaar — Fri, 28 Nov 2014 12:23:17 GMT

The best option is to create correct xml files that do not contain multiple line items and sequence numbers. Alternatively you calculate the maximum numeric and string values for each field. See attached qvw.

Re: XML load into QlikView

Tue, 02 Dec 2014 08:26:33 GMT

Hi Gysbert,

Unfortunatly it not possible to create correct xml files because it s the output of a cashdrawer where multiple sequences means multiple sales.

Your calculation method takes a lot of time. I have to read over 65000 XML files. Is there an other option which takes less time?

Regards,

Liselotte

Re: XML load into QlikView

Gysbert_Wassenaar — Tue, 02 Dec 2014 10:18:54 GMT

Use an XSLT processor to transform the xml files to extract the data you want. Then feed the result of that into Qlikview.

Or just accept multiple records and use chart expressions to aggregate the amounts as needed.