Load multiple files from web server

[marikabi]

dears,

i would need your help in setting a proper data load script.

I need to access several excel files loaded on a web server.

The structure of the file is always the same, same headers and only one sheet.

The FROM path looks like : http://ABC.com/qlik_data/invoicexxx.xslx

As this server is also used for storage, each file has a different name (eg invoice202104.xlsx , invoice202103.xslx etc)

Please how can i load all the files in that directory without declaring each file name?

Also,  is it possible to not declare the tab name? The supplier is using every time a different name, and i would like to avoid having to manipulate with the file changing the tab name.

Many thanks in advance

[MayilVahanan]

Hi 

Try like below, it helps to load multiple files with start with invoice*

Load * from

http://ABC.com/qlik_data/invoice*.xslx

[marikabi]

Dear Mayil,

thanks for your reply, but this is unfortunately not working.

Please would you have any other idea how to solve it?

Thanks again

[MayilVahanan]

Hi 
Am not sure the reason, might be try like below link

https://community.qlik.com/t5/QlikView-App-Dev/Load-multiple-excel-web-embaded-files/td-p/1001521