Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
aaronchandlerwo
New Contributor III

Qlik Sense load script from a text file

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

1 Solution

Accepted Solutions
Partner
Partner

Re: Qlik Sense load script from a text file

please refer to :

Using Include in Qlik Sense

the point is to use lib connections or permit the use of full paths (unceck the standrard reloard mode)

3 Replies
Partner
Partner

Re: Qlik Sense load script from a text file

please refer to :

Using Include in Qlik Sense

the point is to use lib connections or permit the use of full paths (unceck the standrard reloard mode)

aaronchandlerwo
New Contributor III

Re: Qlik Sense load script from a text file

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!!!

Partner
Partner

Re: Qlik Sense load script from a text file

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