Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Change the relative path

Hello everyone,

In my organisation, each developper has the same folder struture : one for the csv files, one for the qvd that are created and so on...

Once they have finished their application, I paste them on the server on which there is the same folder structure.

So we use relative path in the script.

For example, we have :

LOAD * FROM

[..\Source\booking.xlsx]

(ooxml, embedded labels, table is global);

for a file located in : D:\Qlikview_Data\Source\booking.xlsx'

The thing is that I have created another folder in the Source folder so now, the path to go to the booking file is

D:\Qlikview_Data\Source\Source_book\booking.xlsx'

So I modified the script consequently:

LOAD * FROM

[..\Source\Source_book\booking.xlsx]

(ooxml, embedded labels, table is global);

the error is "impossible to open  " : 'D:\Qlikview_Data\Extract\..Source\Source_book\booking.xlsx'

Why does QV search the file into D:\Qlikview_Data\Extract\..Source\Source_book\booking.xlsx  instead of :

D:\Qlikview_Data\Source\Source_book\booking.xlsx ????

I hope I am clear.

Thank you for your help

Laura

Tags (1)
1 Solution

Accepted Solutions
satyadev_j
Valued Contributor

Re: Change the relative path

Hi,

Try below instead. Apparently above path should work.

"..\..\Source\Source_book\booking.xlsx"

4 Replies

Re: Change the relative path

Hi,

You may try with declaring path to a variable as shown below.

let vpath ='D:\qvd\';

Temp:

Load *,subfield(RQ_TARGET,';') as New_RQ_TARGET;

load * Inline

[

PROJECT_NAME,REQ_ID,RQ_TARGET

MMR,2055,;77;84;

MMR,2056,;55;91;98;

]

;

store Temp into  $(vpath)Temp.qvd(qvd);

Regards

ASHFAQ

satyadev_j
Valued Contributor

Re: Change the relative path

Hi,

Try below instead. Apparently above path should work.

"..\..\Source\Source_book\booking.xlsx"

sudeepkm
Valued Contributor III

Re: Change the relative path

can you please attach a screenshot of your folder structure?

Not applicable

Re: Change the relative path

I have found the problem :  it's because I hadn't written ..\Source\Source_book ..

but ..Source\Source_book .. (I did a wrong replace all)

Thank you for your help !

Community Browser