topic Re: Figure out the current path automatically in QlikView

Figure out the current path automatically

Wed, 13 Mar 2013 20:56:31 GMT

Hi, I have the following situation:

I distribute the data files to the needed computers with Dropbox. I have a folder with the QV file and the data files are in a subfolder of this folder.

The pathway is different on each computer till the folder in wich I have the QV file.

Now I am using a Set path=E/....... function. But I have to modify this constant for each computer. Is it a possibility to find out the pathway of the folder in wich the QV file is located?

I could then set a constant with the pathway and use it in the script each time I need to import a new table.

Thank you,

Re: Figure out the current path automatically

Wed, 13 Mar 2013 21:06:05 GMT

Hi,

For this situation, you should use "Relative paths" in your script.

There's an option in the script editor, in "data" sheet, group "Data from files".

Regard,

Ricardo

Re: Figure out the current path automatically

Wed, 13 Mar 2013 21:18:58 GMT

Dear Ricardo, I tried the relative pathways, but I have a QV file in one folder and then I have several subfolders with a lot of othes excell and csv files to import. I need to adress the subfolders. Do you know a workaround for this?

Re: Figure out the current path automatically

Wed, 13 Mar 2013 21:29:48 GMT

Hi Ricardo, it is working with subfolder, I just need to put in the name of the subfolder followd by a Backslash.

Directory;

LOAD Filed_Name

FROM

[New folder\Path Bugetare.xlsx]

(ooxml, embedded labels, table is Sheet1);

Thank you

Re: Figure out the current path automatically

Wed, 13 Mar 2013 21:36:06 GMT

Right!

It's a Relative path.