Script to automatically load multiple Excel files in a folder.

[ashishp]

Hi There 

I am receiving multiple exel files as source data every week and we are placing excel file in folder. 

I am looking to automate the process of loading newly added excel file to existing QVD and store the QVD with new excel data. 

Can you please suggest how we can achieve this in script? 

Thanks in advance,  

[edwin]

check this out:
https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Sense-Load-all-files-from-a-folder/td-p/13...

you should be able to save the file names you already loaded and only look for new ones

[ashishp]

Thanks for updates. 

How to concatenate all files after we use merge script?

[edwin]

i must be missing something.  when you load to a single table, the data from multiple XLS files will be concatenated into that single table.  you can then save to your QVD file