Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible for Qlik Sense's load script to be stored in a text file and referenced instead of the code directly entered?
Example:
In QlikView, my QVWs' code was all stored in associated text files for ease of editing.
QVW Load Script
----------------------------------------------------------------------------------
//Connection
$(Include=hq-datahouse1-datawarehouse.txt);
//QVD Path
$(Include=qvdpath.txt);
//Main Script
$(Include=loader_dim_hour.txt);
----------------------------------------------------------------------------------
the loader_dim_hour.txt was your standard
SQL SELECT * FROM ......
It worked great.
The Connection string and the QVD Path is easy enough to store and manage as a new data connection in Sense, but what about the script itself?
Thank you
please refer to :
the point is to use lib connections or permit the use of full paths (unceck the standrard reloard mode)
please refer to :
the point is to use lib connections or permit the use of full paths (unceck the standrard reloard mode)
Bingo! Thank you very much.
Yup, I just made a shared data connection to a folder containing the text of my load script logic and referenced it thus...
$(Include=[lib://PATH/LoadScript.txt]);
p.s.
No paces!!!
good ! happy it's worked !
Don't forget to close the thread by marking my response in this case as correct
Have a nice day