Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Loading Multiple Excel Files Sharepoint

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?

Labels (2)
2 Replies
Highlighted
Partner
Partner

Create a connection to that web address, and then use that connection to loop for the file list. 

Capture.JPG

Thanks

Mohamed

Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.