Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

3 Replies

Re: XML load into QlikView

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.


talk is cheap, supply exceeds demand
Not applicable

Re: XML load into QlikView

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

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.


talk is cheap, supply exceeds demand
Community Browser