Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
bewiseavi
Contributor
Contributor
‎2019-11-05 07:24 AM

How to read excel as a source file from office 365 share point multile folders in one go

How can we read excel (as a source file) from office 365 share point having 1 parent folders and then many sub folders, each subfolders has a excel file to read in one go.

Any help would be highly appreciated.

482 Views
0 Likes
1 Reply
Brett_Bleess
Former Employee
Former Employee
‎2019-11-11 10:55 AM

Not sure this is exactly what you want, but it is an option:

https://community.qlik.com/t5/Qlik-Design-Blog/Loops-in-the-Script/ba-p/1473543

https://community.qlik.com/t5/Qlik-Design-Blog/Wildcard-data-loading-blah/ba-p/1467768

Sorry I do not have anything better, you may still need to do directory changes, which I know you are trying to avoid.  Someone else may have something better, as my post will kick things back up to the top again.

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.
437 Views
0 Likes