topic Scan folder and find all . qvd in QlikView

Scan folder and find all . qvd

Jogi — Sat, 16 Nov 2024 02:10:46 GMT

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

Re: Scan folder and find all . qvd

Jogi — Mon, 21 Oct 2019 08:55:27 GMT

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')

Re: Scan folder and find all . qvd

atoz1158 — Mon, 21 Oct 2019 09:00:15 GMT

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

Re: Scan folder and find all . qvd

Brett_Bleess — Tue, 29 Oct 2019 12:44:18 GMT

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

Re: Scan folder and find all . qvd

pradeep_s — Fri, 07 Aug 2020 18:39:43 GMT

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