Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

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
Author

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

Gysbert_Wassenaar

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