topic how to load multiple excel files with file name in QlikView

how to load multiple excel files with file name

bushpalaamarnat — Wed, 25 Nov 2020 16:16:04 GMT

Could some one help me load multiple excel files with the same file name and create single qvd?

Re: how to load multiple excel files with file name

stabben23 — Fri, 02 Feb 2018 13:43:08 GMT

use this script:

For each vFileName in Filelist ('C:\Users\xx\Documents\W*.xlsx') //Your path to files

Table:
LOAD
*
FROM
$(vFileName)
(ooxml, no labels, table is Sheet1);
Next vFileName

store Table into Name.qvd(qvd);

Re: how to load multiple excel files with file name

stabben23 — Fri, 02 Feb 2018 13:47:02 GMT

change to this

(ooxml, embedded labels, table is Sheet1)

Re: how to load multiple excel files with file name

bushpalaamarnat — Fri, 02 Feb 2018 14:12:00 GMT

Thank you!

guess, I was not clear in my request. i see that now. The only challenge i have is the data in the week 4 and week 5 are dynamic in nature. some of the feilds like inventory or demand, every week it will change. Hope i am able to make sence. I have about 13 weeks data that get refreshed every week. in a rolling ways.

It is dynamic in nature.