Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
montubhardwaj
Specialist
Specialist

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

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

1 Solution

Accepted Solutions
montubhardwaj
Specialist
Specialist
Author

Hi Dnatividad,

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

Regards,

Sharma

View solution in original post

2 Replies
Qvmaster2019
Creator
Creator

I think you have to comment this out.

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

//          call DoDir (Dir)

//next Dir

montubhardwaj
Specialist
Specialist
Author

Hi Dnatividad,

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

Regards,

Sharma