Scan folder and find all . qvd

[Jogi]

Hi guys, need your help please

I need to create a loop that will scan \folder\folder\folder\ and find all possible .qvds 

and make a list of this . qvds 

[Jogi]

Does anybody knows why it is not working? 

SUB DoDir (Root)
FOR Each Ext in 'qvd'
FOR Each File in filelist (Root&' \*.' &Ext)
LOAD
'$(File)' as Name,
FileSize( '$(File)' ) as Size,
FileTime( '$(File)' ) as FileTime
autogenerate 1;
NEXT File
NEXT Ext

FOR Each Dir in dirlist (Root&' \*' )
call DoDir (Dir)
NEXT Dir
ENDSUB

CALL DoDir('My path')

[atoz1158]

Hi

Can I suggest you have a look at the following.

https://qlikviewcookbook.com/recipes/#squelch-taas-accordion-shortcode-content-11

Under Scripting the List Files item is what I think you need.

Regards

Adrian

[Brett_Bleess]

Mykola, below is a Design Blog link that may be helpful in this case.  If the other post did help, you can use the Accept as Solution button on it to mark that as having worked, but if you still need help after checking the below too, shout back with an update on where you are with things currently.

https://community.qlik.com/t5/Qlik-Design-Blog/Loops-in-the-Script/ba-p/1473543

Regards,
Brett

[pradeep_s]

Hi Jogi,

Please use QlikView Directory Scan Application. This will help you.

https://community.qlik.com/t5/QlikView-Documents/QlikView-Directory-Scan-Application/ta-p/1734223

Thanks