Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
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

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)

View solution in original post

3 Replies
Partner
Partner

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)

View solution in original post

Contributor III
Contributor III

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

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