Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to read all the files using file time

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

Load * from

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

Thanks

Pavan

Tags (1)
Community Browser