Include statement - in Qlik Sense

[jcampbell]

Mike,

I'm using an Include in Data load editor but it's generating an error. This is the syntax I'm using:

$(Include=Load-Script.txt);

Attached is the error Qlik Sense is generating. Is the syntax correct?

Thanks,

Josh

[Michael_Tarallo]

Hi Joshua - check this out:

Disable Standard Mode -

BTW - Are you using Qlik Sense Server or Desktop?

In Qlik Sense, by default file access is disabled via paths (and requires the use of the LIB statement and a creation of a Folder connection).

Here is an example - LIB and Include

Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike

[jcampbell]

Server.

[jcampbell]

Michael,

I've created the data connection and I believe this syntax is correct:

$(Include=lib:\\Scripts (keystone_keystoneapp3)\DEMO\Load-Script.txt);

It is still generating the same error. Any ideas?

Thanks,

Josh

[Michael_Tarallo]

Hi Joshua - I'll build out a sample for you - but perhaps my colleague Jonathan Poole - might be able to assist if he is available.

Jonathan if you have a moment, can you take a look at this?

If not - I will look at, once I am off my call.

Mike

[JonnyPoole · Accepted solution]

Josh - try reversing the direction of your slashes . You'll get the error with back slashes but not forward ones.

$(Include=lib://Scripts (keystone_keystoneapp3)/DEMO/Load-Script.txt);

[jcampbell]

Jonathan,

That did the trick. Thanks!

Josh