topic Load list of files in a Folder in QlikView

Load list of files in a Folder

Josh_Good — Thu, 28 Jul 2011 15:51:02 GMT

Hi,

I am wondering if there is a way to ‘load’ a list of files in aspecified directory/file folder? I have an application need to monitorthe date stamps of files in folder and take action if they have been sitting there past a set threshold of time.

Thanks.

Load list of files in a Folder

danielrozental — Thu, 28 Jul 2011 17:56:10 GMT

Sure, look at functions filelist() and filetime().

Load list of files in a Folder

Josh_Good — Thu, 28 Jul 2011 18:12:50 GMT

Thanks. Here is the code I ended up using

LOAD Distinct FileName() as FileName,

FileTime() as filetime

FROM

[*.txt]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);