topic Change the relative path in QlikView

Change the relative path

Mon, 04 Aug 2014 09:27:39 GMT

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

Re: Change the relative path

ashfaq_haseeb — Mon, 04 Aug 2014 09:41:14 GMT

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

Re: Change the relative path

Anonymous — Mon, 04 Aug 2014 09:48:11 GMT

Hi,

Try below instead. Apparently above path should work.

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

Re: Change the relative path

sudeepkm — Mon, 04 Aug 2014 10:04:40 GMT

can you please attach a screenshot of your folder structure?

Re: Change the relative path

Mon, 04 Aug 2014 10:18:18 GMT

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 !