Using variable to store absolute path and load file using the variable.
Hello! I am working as a co - op (intern) as a BI developer and we are using Qlik Sense for ETL, data integration and reporting. I have a question :
1) I want to use absolute path ([D:\folder]) of a connection instead of reference path ([lib://xyz/abc]) in a variable and use this to replace my load script from [lib://xyz/abc/filename] to $(vABC)\filename; where $(vABC) = '[D:\folder]'.
I am trying but I keep getting some error. Any leads to solve this would be appreciated. 🙂
as far as i know absolute path will not work. actually the connection plays the part of a variable there. you can edit connection it to a different folder and it will still work with existing script
Any specific reason why you want the absolute path?
For security reasons, Qlik Sense in standard mode does not support absolute or relative paths in the data load script or functions and variables that expose the file system.
