Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
I am trying to read qvd names in a loop. However there is a space in the file names and I think this causes it not to work.
(vReportMonth = 202008)
let path_All = '\\server\QlikView\QVData\MyFiles_Vods_ $(vReportMonth)*.qvd' - note there is a space between the '_' and $...
for each file in filelist (path_Alles)
vods:
load
Stuff
From
$(file)(qvd) group by log_date,log_time,func_desc,type ;
CNT = CNT + 1;
next file
It is not picking up any files (files = <null>) - I am assuming I need to 'tell' the variable implicitly that there is a space? Any help please?
Thank you!
Then check (maybe with TRACE) that both variables vReportMonth + path_All contain the expected content and that path is really valid. Further change the variable-call within the filelist-loop to:
for each file in filelist ('$(path_Alles)')
... just see path_All <> path_Alles ...
- Marcus
Yes, the path needs to be wrapped like:
load Stuff From [$(file)] (qvd);
- Marcus
Hi Marcus, Thanks for your reply.
Changed as you suggested, still same error.
Then check (maybe with TRACE) that both variables vReportMonth + path_All contain the expected content and that path is really valid. Further change the variable-call within the filelist-loop to:
for each file in filelist ('$(path_Alles)')
... just see path_All <> path_Alles ...
- Marcus