Question: How to load multiple excel files from SharePoint to Qlik Sense using Qlik Web Connector?
I have a module Sales in SharePoint. It has 10 excel files. Now in order to create connection string for these 10 files in Qlik Sense what I am currently doing is
From the ListFiles I get all 10 files with their unique ids and name. And now I am creating a connection string for each unique Id which generates a different Url for qlik sense one by one..
I have modules in SharePoint which are as big as 100 files or even more. I want that instead of wasting so many man hours on creating connection string for each file individually.. How can I load multiple excel files from SharePoint to Qlik Sense in one go?????