Load only most current file

schneider2037 — Wed, 25 Nov 2020 16:16:04 GMT

I have a situation where .xls files are auto-populating into a folder daily.

Trying to figure out how to create a LOAD for ONLY the most current file (predicated on converting the trailing epoch time). Don't want to have a human update script every day to accomplish. That will fail, and frankly I'm not up for working on the weekends!

I've seen several examples with creating different variables that are close, but not sure how to "split" the below filenames apart, convert the 13 char epoch time (which includes to the microsecond) into only "mm/dd/yyyy", then lastly load the filename where the converted epoch time stamp date = today's date.

FileName

Service_Issue_Past7days__1527242456781

Service_Issue_Past7days__1527156056113

Service_Issue_Past7days__1526983257617

Service_Issue_Past7days__1526896855137

Service_Issue_Past7days__1526637688464

Or...could this be accomplished by simply a "get the trailing number, and then only load the file with the max number?"

THANKS!
Jonathan

Re: Load only most current file

Chanty4u — Fri, 25 May 2018 18:25:06 GMT

try this

Load the latest file of a folder

topic Re: Load only most current file in QlikView

Load only most current file

Re: Load only most current file