Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've read lots on here that it's not possible to dynamically load multiple excel files from SharePoint but is it possible to do it using a loop in a file list, with the web file path as the file list?
For each file in FileList('https://test.sp.test.com/sites/dept/it/Flat%20File%20Repository/IT/test/Snapshots/$(vFileName).csv')
Would this work?
Create a connection to that web address, and then use that connection to loop for the file list.
Thanks
Mohamed
The missing piece here may be in the following Design Blog post:
https://community.qlik.com/t5/Qlik-Design-Blog/Loops-in-the-Script/ba-p/1473543
Have a read through that if you have not sorted things yet and hopefully that may get you the piece you are missing.
Regards,
Brett