topic Office 365 SharePoint connector SP Lists / Excel File queries in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Office-365-SharePoint-connector-SP-Lists-Excel-File-queries/m-p/105591#M6329 <HTML><HEAD></HEAD><BODY><P>Hi Experts, </P><P></P><P>I have few queries related to new connector release by Qlik: Office 365 SP</P><P></P><UL><LI>When I try to reference an excel file hosted on SP, there’s no option to provide Worksheet name.(if workbook has multiple worksheets)&nbsp;&nbsp; How can we refer data from a particular sheet?&nbsp; </LI></UL><P></P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/208304_1.png" style="height: auto;" /></P><P></P><P></P><UL><LI>When I try to reference SP lists into Qlik, the query generates lot of additional columns along with the actual ones.</LI></UL><P>Also, some of the columns were renamed automatically. How can we use default columns/fields without being renamed?</P><P></P><P><IMG alt="rename.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/208306_rename.png" style="height: 351px; width: 620px;" /></P></BODY></HTML> Fri, 02 Apr 2021 07:47:46 GMT saurabh_handa 2021-04-02T07:47:46Z Office 365 SharePoint connector SP Lists / Excel File queries https://community.qlik.com/t5/Connectivity-Data-Prep/Office-365-SharePoint-connector-SP-Lists-Excel-File-queries/m-p/105591#M6329 <HTML><HEAD></HEAD><BODY><P>Hi Experts, </P><P></P><P>I have few queries related to new connector release by Qlik: Office 365 SP</P><P></P><UL><LI>When I try to reference an excel file hosted on SP, there’s no option to provide Worksheet name.(if workbook has multiple worksheets)&nbsp;&nbsp; How can we refer data from a particular sheet?&nbsp; </LI></UL><P></P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/208304_1.png" style="height: auto;" /></P><P></P><P></P><UL><LI>When I try to reference SP lists into Qlik, the query generates lot of additional columns along with the actual ones.</LI></UL><P>Also, some of the columns were renamed automatically. How can we use default columns/fields without being renamed?</P><P></P><P><IMG alt="rename.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/208306_rename.png" style="height: 351px; width: 620px;" /></P></BODY></HTML> Fri, 02 Apr 2021 07:47:46 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Office-365-SharePoint-connector-SP-Lists-Excel-File-queries/m-p/105591#M6329 saurabh_handa 2021-04-02T07:47:46Z