Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

How to Load Multiple Excel files in a single time

hi to everyone i have multiple excel files i like this

BMAC_R2_CR_PBTV_ACCOUNTS_2016-04-07

BMAC_R2_CR_PBTV_ACCOUNTS_2016-04-08

BMAC_R2_CR_PBTV_ACCOUNTS_2016-04-11

BMAC_R2_CR_PBTV_ACCOUNTS_2016-04-12

BMAC_R2_CR_PBTV_ACCOUNTS_2016-04-13

BMAC_R2_CR_PBTV_ACCOUNTS_2016-04-14

BMAC_R2_CR_PBTV_ACCOUNTS_2016-04-15

i have to load all the files at a same time in qlikview can u help me

1 Solution

Accepted Solutions

Re: How to Load Multiple Excel files in a single time

With a wildcard load:

MyTable:

LOAD

     *

FROM

     BMAC_R2_CR_PBTV_ACCOUNTS*.xlsx

     (ooxml, embedded labels, table is Sheet1)

     ;


talk is cheap, supply exceeds demand
1 Reply

Re: How to Load Multiple Excel files in a single time

With a wildcard load:

MyTable:

LOAD

     *

FROM

     BMAC_R2_CR_PBTV_ACCOUNTS*.xlsx

     (ooxml, embedded labels, table is Sheet1)

     ;


talk is cheap, supply exceeds demand
Community Browser