Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Not reload when Folder is Empty

hello

I do a reload if my directory is not empty.

Does anyone have a solution for this?

thx

1 Reply
fosuzuki
Partner - Specialist III
Partner - Specialist III

Hi,

you could use a for each loop to check if there are files in a folder. From the QV Help, a sample code:

SUB DoDir (Root)

    FOR Each Ext in 'qvw', 'qva', 'qvo', 'qvs'

        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 ('C:')

Hope this helps you

Fernando