Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

loading multiple excel sheets into one table

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?

1 Solution

Accepted Solutions
rwunderlich

add the CONCATENATE keyword to the second load

CONCATENATE

LOAD

Year,

     ID,

     TypeCode,....

-Rob

View solution in original post

1 Reply
rwunderlich

add the CONCATENATE keyword to the second load

CONCATENATE

LOAD

Year,

     ID,

     TypeCode,....

-Rob