topic Re: multi tables load in QlikView

multi tables load

Anonymous — Thu, 19 Mar 2015 22:04:55 GMT

I have attached 3 tables,

Item Sales contains Item, store and sales per week.

Item Budget contains Item, area and weekly budget,

Store Info contains store and its area.

Also, column week in first 2 tables has totally different value.

What script should I use to load them correctly? Please share the script instead of qvw as I could not open 3rd party's qvw file. thanks.

maxgro — Thu, 19 Mar 2015 22:16:09 GMT

Correctly depends on your requirements

Sales:

LOAD [Item #],

[Store #],

Sales,

replace(Week, '#', '') as Week,

'Sales'as Table

FROM

[Item Sales.xls]

(biff, embedded labels, table is Sheet1$);

left join (Sales)

LOAD [Store #],

Area

FROM

[Store Info.xls]

(biff, embedded labels, table is Sheet1$);

Concatenate (Sales)

LOAD [Item #],

Area,

Budget,

replace(Week, 'Week', '') as Week,

'Budget' as Table

FROM

[Item Budget.xls]

(biff, embedded labels, table is Sheet1$);

Anonymous — Fri, 20 Mar 2015 00:25:53 GMT

Perfect! Thanks.