how to load multiple excel files with file name

[bushpalaamarnat]

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

[stabben23 · Accepted solution]

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

[stabben23]

change to this

(ooxml, embedded labels, table is Sheet1)

[bushpalaamarnat]

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.