topic Space in File name while reading in Loop, maybe causing problem? in QlikView

Space in File name while reading in Loop, maybe causing problem?

QFanatic — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Space in File name while reading in Loop, maybe causing problem?

marcus_sommer — Tue, 22 Sep 2020 06:59:42 GMT

Yes, the path needs to be wrapped like:

load Stuff From [$(file)] (qvd);

- Marcus

Re: Space in File name while reading in Loop, maybe causing problem?

QFanatic — Tue, 22 Sep 2020 07:30:01 GMT

Hi Marcus, Thanks for your reply.

Changed as you suggested, still same error.

Re: Space in File name while reading in Loop, maybe causing problem?

marcus_sommer — Tue, 22 Sep 2020 10:59:18 GMT

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