topic Re: loading different excel files at a time in QlikView

loading different excel files at a time

Anonymous — Wed, 26 Nov 2014 18:41:43 GMT

hi all,

i have different excel files with different names .so how to load all these files at a time .

Thanks

its_anandrjs — Wed, 26 Nov 2014 18:54:14 GMT

Hi,

There are many ways for this try this ways

LOAD *

FROM

(ooxml, no labels, table is sheet1);

LOAD *

FROM *.xlsx
(ooxml, embedded labels, table is [$(*)]);

Regards

Anand

Anonymous — Wed, 26 Nov 2014 19:04:45 GMT

hi first of all thanks for your reply , i have another doubt if we have different file formats like .txt, xlsx etc then how to load ?

its_anandrjs — Wed, 26 Nov 2014 19:48:37 GMT

Hi,

If you can read this post it provides info for the multiple file loading

Regards

Anand