Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Multiple xlsx files in Sharepoint into Qlik Sense

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.

Labels (4)
5 Replies
Highlighted
Contributor
Contributor

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
Akhilesh Yadav
Qlik Developer
Mumbai
Highlighted
Creator II
Creator II

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."
Partner
Partner

Hi ,

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

Regards,
Puneet

Highlighted
Creator II
Creator II

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.

 

Highlighted
Partner
Partner

Hi Divya,

Thanks for the solution.

Regards,

Puneet Agarwal