Change the relative path

[#1]

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

[ashfaq_haseeb]

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

[Anonymous · Accepted solution]

Hi,

Try below instead. Apparently above path should work.

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

[sudeepkm]

can you please attach a screenshot of your folder structure?

[#5]

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 !