Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
khaycock
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
lazurens
Partner
Partner

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

Capture.JPG

Thanks

Mohamed

Brett_Bleess
Support (Former)
Support (Former)

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.