Discussion board where members can learn more about Qlik Sense Data Connectivity.
I hope that you can help me, I need give the path that include the Connection lib,
i define a Connection named "Root" and this include the path C:/Users
I like that give the path in the scripts
Set a variable to include into another sentence. Like this
SET vRootPath ='Lib:\\Root';
It will help you.
Thanks for your help, but I do not need to do it, What I need is a function or variable that allows me to get the path store in the connection "Root"
What are you hoping to then do with this path ?
I am insert data in postgresql, i need the path for i can insert data
the comand SQL is
SQL copy nombre_tabla from 'C:/Users/RC/Documents/Qlik/nombre:archivo.csv' USING delimiters ';'
Lib:RooT --> C:/Users/RC/Documents/Qlik
Any reason not to simply hard code the path in your sql ?
because en my team we are 3 persons, each person have a path different, the idea is get the path that each one config in the connection
Por que en mi equipo somos 3 personas, cada persona tiene una ruta diferente, la idea es obtener la ruta que cada uno configuro en la conexión
Would I be correct in assuming you are all using Qlik Sense Desktop as opposed to Server ?
Certainly not elegant but it should work.
Alternatively you could flip all 3 of your Qlik Sense Desktops into legacy mode and use the Qlik system variable QvWorkPath, but that would be a sledgehammer to crack a nut.
Very thank you for the help,
We are working with GIT then when someone the we do a change in any file it is synchronized for all.
The idea is to be able to get the path in a dynamic way.
For the moment everyone configured the path in a variable.
What creates the csv file you wish store into your PostgreSQL database ?