loading multiple excel sheets into one table

Tue, 03 Feb 2015 23:54:45 GMT

Hi,

I am loading an excel file with two sheets as follows:

LOAD

Year,

ID,

[Entity Name],

City,

State,

Zip,

TypeCode,

ManfCode,

FROM

[myfile.xlsx]

(ooxml, embedded labels, table is table1);

LOAD

Year,

ID,

TypeCode,

FactorCode,

ManfCode

FROM

[myfile.xlsx]

(ooxml, embedded labels, table is table2);

Problem here is I get two tables in qv data model with synthetic keys between them. How can I avoid this and load both worksheets into one table in qv?

Re: loading multiple excel sheets into one table

rwunderlich — Wed, 04 Feb 2015 01:33:40 GMT

add the CONCATENATE keyword to the second load

CONCATENATE

LOAD

Year,

ID,

TypeCode,....

-Rob

topic loading multiple excel sheets into one table in QlikView

loading multiple excel sheets into one table

Re: loading multiple excel sheets into one table