Loading Data from multiple excel files which is placed in sharepoint into Qliksense
Can you share the solution for loading data from multiple excel files placed in SharePoint by using Qliksense and web connector.Currently I am able to load it by creating separate connections.Is it possible to load data from multiple excel files by using single connection.
The article and video you shared shows how to create a connection to a single file in SharePoint.
However, the query asks how to connect to multiple files in a SharePoint location using a single connection.
I have the same issue in that new source files are saved daily to a SharePoint location. The structure of each file is identical, with each file having the latest day's data.
I have created a connection to the first file using the 'Qlik Office 365 Sharepoint Connector', but I need a method of loading all files in the SharePoint folder, without having to create a new connection for each file.
Can you advise on how this can be done using the Sharepoint Connector?