Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have couple of questions :
1) when I define my share point web address with a parameter(for example, I called it "vSharepointPath") , should I write it with the "http://" or without it ?
2) when I do the select from the excel file in the share point like that :
LOAD [Year]
FROM [$(vSharepointPath)excel_file.xlsx] (ooxml, embedded labels, table is [sheet_name]);
the data does not load at all - what am I doing wrong in my definition ?
thanks,
Moni
thanks you for your answer ,
but still I get difficult to understand how to use the URL with the listGUID:
when I trying to load the file (excel) from it like that :
load *
from [https://xx.sharepoint.com/teams/xxxxxxxx/_layouts/15/policycts.aspx?List={ADF28588-EBE9-49D5-ABE4-E2...] (ooxml, embedded labels, table is [sheet_name])
it doesn't work .
where do I put the file name here in the link ?
I have on the share point 3 excels files , how do I address to a specific one with this url ?
thanks
Moni