topic Re: Get path of the conexion lib://Root in Connectivity & Data Prep

Get path of the conexion lib://Root

Anonymous — Mon, 18 Dec 2017 16:21:52 GMT

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

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

uroboros — Mon, 18 Dec 2017 16:47:08 GMT

Hi Diego,

Set a variable to include into another sentence. Like this

SET vRootPath ='Lib:\\Root';

It will help you.

regards

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

Anonymous — Mon, 18 Dec 2017 17:07:25 GMT

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

Anonymous — Mon, 18 Dec 2017 18:53:19 GMT

What are you hoping to then do with this path ?

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

Anonymous — Mon, 18 Dec 2017 19:01:32 GMT

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

Anonymous — Mon, 18 Dec 2017 19:32:11 GMT

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

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

Anonymous — Mon, 18 Dec 2017 19:42:53 GMT

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

Anonymous — Mon, 18 Dec 2017 19:57:40 GMT

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.

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

Anonymous — Mon, 18 Dec 2017 20:26:01 GMT

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

Anonymous — Mon, 18 Dec 2017 20:37:24 GMT

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

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

Anonymous — Mon, 18 Dec 2017 21:10:42 GMT

Qliksense create the file csv

vPathCSV --> Lib://Root

vNameTable --> Tabla1

vDelimiter --> ','

STORE '$(vNameTable)' into '$(vPathCSV)$(vNameTable).csv' (txt, delimiter is '$(vDelimiter)');