topic Re: Load multiple files from web server in QlikView

Load multiple files from web server

marikabi — Mon, 26 Jan 2026 21:26:37 GMT

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

Re: Load multiple files from web server

MayilVahanan — Tue, 27 Apr 2021 10:59:53 GMT

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

Load * from

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

Re: Load multiple files from web server

marikabi — Tue, 04 May 2021 12:42:40 GMT

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

Re: Load multiple files from web server

MayilVahanan — Wed, 05 May 2021 02:24:14 GMT

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