Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

multi tables load

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.

1 Solution

Accepted Solutions
maxgro
MVP
MVP

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$);

View solution in original post

2 Replies
maxgro
MVP
MVP

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
Not applicable
Author

Perfect! Thanks.