Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

dagomezl
Contributor III

Get path of the conexion lib://Root

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

10 Replies
uroboros
Contributor

Re: Get path of the conexion lib://Root

Hi Diego,

Set a variable to include into another sentence. Like this

SET vRootPath ='Lib:\\Root';

It will help you.

regards

dagomezl
Contributor III

Re: Get path of the conexion lib://Root

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"

Re: Get path of the conexion lib://Root

What are you hoping to then do with this path ?

dagomezl
Contributor III

Re: Get path of the conexion lib://Root

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

Re: Get path of the conexion lib://Root

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

dagomezl
Contributor III

Re: Get path of the conexion lib://Root

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

Re: Get path of the conexion lib://Root

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.

dagomezl
Contributor III

Re: Get path of the conexion lib://Root

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.

Re: Get path of the conexion lib://Root

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

Community Browser