Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewforum
Creator II
Creator II

Scan file system in optimized way!

Hi All,

Is there is any optimized way to scan the file system other than using the below code which generates very large log file. Please help!

  

// list all QV related files on disk

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
end sub

10 Replies
qlikviewforum
Creator II
Creator II
Author

Hi David,

That I have already been trying but still no luck to read the data from unstructured file format. Below the thread which I have created for that. It would be great if you can provide some solution there.

Reading line by line to get the size of each file with full path

Thanks,