3 Replies Latest reply: Jan 19, 2018 9:14 AM by omar bensalem RSS

    Qlik Sense load script from a text file

    Aaron Chandler-Worth

      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