topic Re: Using variable to store absolute path and load file using the variable. in App Development

Using variable to store absolute path and load file using the variable.

deborahs — Sat, 16 Nov 2024 21:09:39 GMT

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. 🙂

Re: Using variable to store absolute path and load file using the variable.

dplr-rn — Thu, 28 Mar 2019 15:57:15 GMT

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?

Re: Using variable to store absolute path and load file using the variable.

dplr-rn — Thu, 28 Mar 2019 16:15:23 GMT

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.

see below
https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/LoadData/file-system-access-restriction.htm