Load Multiple Excel Files from SharePoint site and create a single table in Qlik sense.

[Anuhyak1]

I'm able to load a table  from list of Excel files in a SharePoint location. This is all done via Web Connectors. The code and results look like this.

LIB CONNECT TO RnD GDS - GPSETraining

LOAD

    UniqueId,

   Name,

    title,

    id,

    updated

FROM [lib://RnD GDS - GPSETraining]

(qvx);

Attached excel file that contains UniqueId, Name.

Initially load all LEAD ,SABA, Qlik files separately and finally concatenate them to create a giant big table.

New files are added to the SharePoint location monthly and would need to automatically be appended to big Table.

Could you please help me with the script for this scenario in QlikSense.

[nhoover]

In cases like these, I used Excel Power Query to perform the append operation and Qlik to grab the final output.