Get path of the conexion lib://Root

[Anonymous]

Hi guys,

I hope that you can help me, I need give the path that include the Connection lib,

for example:

i define a Connection named "Root" and this include the path C:/Users

I like that give the path in the scripts

[uroboros]

Hi Diego,

Set a variable to include into another sentence. Like this

SET vRootPath ='Lib:\\Root';

It will help you.

regards

[Anonymous]

Hello,

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"

[Anonymous]

What are you hoping to then do with this path ?

[Anonymous]

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

[Anonymous]

Any reason not to simply hard code the path in your sql ?

[Anonymous]

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

---- Spanish

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

[Anonymous]

Would I be correct in assuming you are all using Qlik Sense Desktop as opposed to Server ?

• And all 3 of you will set up your own connection to your own folder path ?
• So if all 3 of you are editing the data connection in your own version of the qvf, why not all 3 of you edit the path in the sql as well ?

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.

[Anonymous]

Hi Bill,

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.

[Anonymous]

What creates the csv file you wish store into your PostgreSQL database ?