Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
saurabh_handa
Contributor III
Contributor III
‎2018-07-19 08:15 AM

Office 365 SharePoint connector SP Lists / Excel File queries

Hi Experts,

I have few queries related to new connector release by Qlik: Office 365 SP

  • When I try to reference an excel file hosted on SP, there’s no option to provide Worksheet name.(if workbook has multiple worksheets)   How can we refer data from a particular sheet? 

1.png

  • When I try to reference SP lists into Qlik, the query generates lot of additional columns along with the actual ones.

Also, some of the columns were renamed automatically. How can we use default columns/fields without being renamed?

rename.png

1,064 Views
0 Likes
0 Replies