Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
In Qlik Sense Desktop 0.96 I was able to load an excel file using a variable for the path
let vFolderPath = 'C:\MasterFiles\';
Table1:
LOAD *
FROM $(vFolderPath)MyFile.xlsx (ooxml, embedded labels, table is Sheet1);
I upgraded to Qlik Sense Desktop 1.0.0 Build 21.ms8 and when I reload this now I get the following error message:
LOAD statement only works with lib:// paths in this script mode
So my question is:
From Qlik Sense Desktop version 1 onwards, must you create a Folder Data Connection?
Is there still a way to load a file using a FROM statement with a variable pointing to the path (rather than using a folder connection library). The reason I'm asking this is because when I share a app to another user I want to allow the user to simply change the path in the variable (use a trick or two for this to minimize user input) to allow that user to also load data from a file without having to edit the folder connection
I have the same question.
LET vDir = 'C\Users\' '\Documents';
And then I would like to create a data connection with this path
For exemple :
But Qlik Sense does not allowed this connection.