topic Re: Multiple xlsx files in Sharepoint into Qlik Sense in Connectivity & Data Prep

Multiple xlsx files in Sharepoint into Qlik Sense

divya_anand — Wed, 15 Dec 2021 18:40:06 GMT

Hi,

I have several .xlsx files in a SharePoint page named as below

ABC 1.xlsx

ABC 2.xlsx

ABC 3.xlsx

etc...

I was able to provide the link of each xlsx file under "WEB FILE" in Qlik Sense and create a connection for every file and concatenate all the data.

My question : Is it possible to create just 1 connection (ABC *. xlsx) and Qlik Sense loads the data from all the files in this location?

Thank you.

Re: Multiple xlsx files in Sharepoint into Qlik Sense

akhi9219 — Wed, 20 Feb 2019 10:52:14 GMT

Dear Divya,

It is possible just create data connection for location where all the files named ABC*.xlsx are placed.

Load *
FROM [lib://ABC*.xlsx]

Regards,
Akhilesh

Re: Multiple xlsx files in Sharepoint into Qlik Sense

divya_anand — Thu, 21 Feb 2019 07:33:07 GMT

Hi Akhilesh,
I am unable to create a link to the page. Which of the below 2 formats should I use to create the connection for the page?
1. https://ABC@XYZ.com/BI/Qlik/Qlik%20Sense%20(Report)/Tracking sheet
2. \\ABC@XYZ.com\BI\Qlik\Qlik Sense (Report)\Tracking sheet

I actually tried both, but it throws a message saying "An Error Occurred: No table found in the HTML file."

Re: Multiple xlsx files in Sharepoint into Qlik Sense

puneetagarwal — Fri, 12 Jul 2019 11:58:37 GMT

Hi ,

I am facing the same issue did you get any solution for this?

Regards,
Puneet

Re: Multiple xlsx files in Sharepoint into Qlik Sense

divya_anand — Fri, 12 Jul 2019 12:10:11 GMT

Hi,

I did not find a solution. However, I found a workaround.

It is not possible to have a variable in the link & run a for loop over multiple values. Hence, I have created a QVD generator in QlikView that will run a for loop over all the similar files in one location and store the consolidated data in a QVD and I use this QVD data as the source for my Qlik Sense report.

Re: Multiple xlsx files in Sharepoint into Qlik Sense

puneetagarwal — Thu, 01 Aug 2019 11:33:58 GMT

Hi Divya,

Thanks for the solution.

Regards,

Puneet Agarwal