topic Re: Load Orders from WEB in QlikView

Load Orders from WEB

gidon500 — Tue, 30 Dec 2014 14:54:00 GMT

my customer have a sales web sight

he get every daye a list of orders

each order is in one line

if the order consist more than one item we get a parameter No-of-items

the culmnes that come after this are part,price,qty

if the are 3 items we get the same set 3 times part,price,qty ,part,price,qty ,part,price,qty

how can i read the colums to get a table for each order

enclosed is a demo file

thanks

gidon

Re: Load Orders from WEB

NickHoff — Tue, 30 Dec 2014 15:28:29 GMT

Use the cross table wizard to modify the columns into the table format you'd like. Another solution would be to do the ETL prior to loading the data into Qlikview with the clients database.

The link below has a good explanation of the fields and their description.

A Blog for QlikView Developers: Cross Table

Re: Load Orders from WEB

francoiscave — Tue, 30 Dec 2014 15:31:27 GMT

Hi Gidon,

From Load script >> Web files >> Give internet file location or type the URL

François