Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

deere2013
New Contributor II

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.

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Loading data from 3 different worksheets in Excel into one table

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

3 Replies
awhitfield
Esteemed Contributor

Re: Loading data from 3 different worksheets in Excel into one table

Hi Todd,

can you upload your xls?

Andy

deere2013
New Contributor II

Re: Loading data from 3 different worksheets in Excel into one table

attached

MVP
MVP

Re: Loading data from 3 different worksheets in Excel into one table

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

Community Browser