Load Orders from WEB

[gidon500]

hi

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

[NickHoff]

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

[francoiscave]

Hi Gidon,

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

François