topic Loading data from 3 different worksheets in Excel into one table in QlikView

Loading data from 3 different worksheets in Excel into one table

Anonymous — Fri, 12 Jun 2015 15:42:00 GMT

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.

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

awhitfield — Fri, 12 Jun 2015 15:50:19 GMT

Hi Todd,

can you upload your xls?

Andy

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

Anonymous — Fri, 12 Jun 2015 16:02:58 GMT

attached

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

maxgro — Fri, 12 Jun 2015 16:12:37 GMT

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