How to read LOG files inside a specific folder and not it's subfolder

montubhardwaj — Mon, 13 Feb 2012 01:08:44 GMT

Hi All,

I am using the below mentioned code to read QV log files from folder.

Sub DoDir (Root)

//for each Ext in 'qvw', 'qvo', 'qvs', 'qvt', 'qvd'
for each Ext in 'log'

for each File in filelist (Root&'\*.' &Ext)

FilesName_Temp1:
Load '$(File)' as Name

autogenerate 1;

next File

next Ext

for each Dir in dirlist (Root&'\*' )

call DoDir (Dir)

next Dir

end sub

Set LogEnviron='Production';
call DoDir ('\\production\d$\QV App') ;

FilesName_Temp2:
Load Left(Name,-1) as Name1
resident FilesName_Temp1;

There are subfolder under "QV App" folder from where I am reading the logs. It is working fine but the problem is this cose is pulling all the log files from subfolders also. I specifically want to pull only from "QV App" folder and not from subfolders.

Any suggestions?

Thanks in advance.

Regards,

Sharma

How to read LOG files inside a specific folder and not it's subfolder

Qvmaster2019 — Mon, 13 Feb 2012 04:01:58 GMT

I think you have to comment this out.

//for each Dir in dirlist (Root&'\*' )

// call DoDir (Dir)

//next Dir

How to read LOG files inside a specific folder and not it's subfolder

montubhardwaj — Mon, 13 Feb 2012 04:58:07 GMT

Hi Dnatividad,

Thanks much. It worked. I completely missed this. Thanks again.:)

Regards,

Sharma

topic How to read LOG files inside a specific folder and not it's subfolder in QlikView

How to read LOG files inside a specific folder and not it's subfolder

How to read LOG files inside a specific folder and not it's subfolder

How to read LOG files inside a specific folder and not it's subfolder