loading multiple excel sheets into one table

[#1]

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?

[rwunderlich · Accepted solution]

add the CONCATENATE keyword to the second load

CONCATENATE

LOAD

Year,

     ID,

     TypeCode,....

-Rob