Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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