topic Re: Load specific files from a directory using FileTime in QlikView

Load specific files from a directory using FileTime

kdmarkee — Sat, 16 Nov 2024 18:24:10 GMT

In my QlikView script, I want to load all pdf files with a Date Created date of today, and although is seems simple to do, I cannot seem to get anything working. Using these examples, can someone help with the code? Thanks.

My directory: \\NP\DemogData\

My Files all have different names...

Today's files: file01.pdf, file02.pdf, file03.pdf (the sript should load these)
Older files in the directory: file22.pdf, file36.pdf, file 45.pdf (the script would ignore these)

Thanks.

Re: Load specific files from a directory using FileTime

Nicole-Smith — Tue, 07 Jul 2020 22:03:31 GMT

Code like this should work (I've tested on my own items):

FOR EACH vFile in FileList('\\NP\DemogData\') IF FileTime('$(vFile)') >= DAYSTART(NOW()) THEN TRACE Load $(vFile); ENDIF NEXT

You might need to update the FileList statement to use the connection where your files are (in case I don't have it fully correct). You would then add your load statement inside of the IF/ENDIF where the TRACE is.

Re: Load specific files from a directory using FileTime

kdmarkee — Wed, 08 Jul 2020 20:47:59 GMT

Thanks a bunch! I was over complicating it... I was trying to write code that would only look at date for the loading and probably didn't have my loop logic correct either. Your code is simple and gets the job done, works great.