Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try below instead. Apparently above path should work.
"..\..\Source\Source_book\booking.xlsx"
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
Hi,
Try below instead. Apparently above path should work.
"..\..\Source\Source_book\booking.xlsx"
can you please attach a screenshot of your folder structure?
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 !