topic Re: How to filter inside a for loop in subroutine in QlikView

How to filter inside a for loop in subroutine

shansundar — Tue, 21 Mar 2017 03:48:50 GMT

Hi Qlikers,

I need to filter a particular named txt files from the root folder (including all sub folders in it). I'm using the following sub routine and then filtering the sub routine result set to achieve the desired result.

sub ScanFolder(Root)

for each FileExtension in 'txt'

for each FoundFile in filelist( Root & '\*.' & FileExtension)

FileList:

LOAD '$(FoundFile)' as SourceFile,

FileTime( '$(FoundFile)' ) as Filetime

AUTOGENERATE 1;

Set vConcatenate = Concatenate;

next FoundFile

next FileExtension

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

call ScanFolder(SubDirectory)

next SubDirectory

end sub;

Call ScanFolder ('myfolder\Log');

FinalFileList:

NOCONCATENATE

LOAD

SourceFile,

Filetime

RESIDENT FileList

WHERE SourceFile LIKE '*Reload_Task_Check';

My question is it is possible to filter the name of the txt file inside the subroutine itself? Can you please help me here.

Thanks,

Shan S

Re: How to filter inside a for loop in subroutine

marcus_sommer — Tue, 21 Mar 2017 08:29:07 GMT

Try this:

...

for each FoundFile in filelist( Root & '\*.' & FileExtension)

if '$(FoundFile)' = 'xxx' then

...

else

...

end if

next

...

- Marcus

Re: How to filter inside a for loop in subroutine

Peter_Cammaert — Tue, 21 Mar 2017 08:38:48 GMT

or add the known part of the file name to look for to the wildcard specification in your inner for loop. Like

for each FoundFile in filelist( Root & '\*Reload_Task_Check.' & FileExtension)

Re: How to filter inside a for loop in subroutine

shansundar — Tue, 21 Mar 2017 09:59:37 GMT

I have included IF condition and it works fine.

Thanks,

Shan S