How to read all the files using file time

Mon, 20 Oct 2014 11:14:39 GMT

Hi Friends,

I am trying to load files only which are updated in this month using the code

DirectoriesToScan:
LOAD * INLINE [
Dirspec
D:\Project LAC Reconciliation UI\Data\OGIS
]
;

SUB doDir (dir)
FOR EACH file in filelist('$(dir)' & '\*.txt')
   Files:
LOAD
'$(file)' as FilePath,
FileSize('$(file)') as FileSize,
FileTime('$(file)') as FileTime,
if(FileTime( '$(file)' ) >= MonthStart(Today()), 1,'0') as FlagRead,
subfield('$(file)', '.', -1) as FileExtension,
subfield('$(file)', '\', -1) as FileName,
subfield (subfield('$(file)', '\', -1),'.' ,1) as Name
AUTOGENERATE 1
;
NEXT
FOR EACH subdir in dirlist( '$(dir)' & '\*' )
CALL doDir('$(subdir)')
NEXT
END SUB
SUB doRoot (root)
FOR EACH subdir in dirlist( '$(root)' )
   CALL doDir('$(subdir)')
NEXT
END SUB
FOR i = 0 to FieldValueCount('Dirspec')
Call doRoot(FieldValue('Dirspec',$(i)));
NEXT i
let ft=peek('FlagRead');
let fn=peek('FileName');
trace ft=$(ft);
if ($(ft)=1) then

Load * from

But its loading only few files, stop at when it reaches the Non-Updated file

Thanks

Pavan

topic How to read all the files using file time in QlikView

How to read all the files using file time