Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try like below, it helps to load multiple files with start with invoice*
Load * from
http://ABC.com/qlik_data/invoice*.xslx
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
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