Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Loading data from 3 different worksheets in Excel into one table

I have a workbook that has 3 different sheets where information in each sheet  (column headers) are the same, but the data is different.  I want to load all three into the same table.  How do I do this without joining on all the fields.

1 Solution

Accepted Solutions
maxgro
MVP
MVP

table:

LOAD *

FROM

[Multiple worksheet.xlsx]

(ooxml, embedded labels, table is [2015 EFD]);

concatenate (table)

load *

FROM

[Multiple worksheet.xlsx]

(ooxml, embedded labels, table is Active);

concatenate (table)

load *

FROM

[Multiple worksheet.xlsx]

(ooxml, embedded labels, table is [EFD History]);

View solution in original post

3 Replies
awhitfield
Partner - Champion
Partner - Champion

Hi Todd,

can you upload your xls?

Andy

Anonymous
Not applicable
Author

attached

maxgro
MVP
MVP

table:

LOAD *

FROM

[Multiple worksheet.xlsx]

(ooxml, embedded labels, table is [2015 EFD]);

concatenate (table)

load *

FROM

[Multiple worksheet.xlsx]

(ooxml, embedded labels, table is Active);

concatenate (table)

load *

FROM

[Multiple worksheet.xlsx]

(ooxml, embedded labels, table is [EFD History]);