I am trying to move a script from QlikView to Qlik Sense which loads an excel file from SharePoint. The script does not run and gives an "Invalid Path" error when I try to load using this format:
When I change to a UNC path (e.g. \\sharepoint\site\subsite), I get the following error:
LOAD statement only works with lib:// paths in this script mode
I have more experience with QlikView, so perhaps there is an easy way to resolve this.
Can anyone share a working solution?
Is there a way that I can set up my data sources to load in the same way as Qlikview?