Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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
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
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