topic Re: load latest file based on todays date in QlikView

load latest file based on todays date

surajap123 — Tue, 15 Mar 2022 10:36:17 GMT

Hi There,

I have the filename in the below format and I want to only load the file if it belongs to today's date in the folder. If not, then don't load.

FileName:
DataFile_YYYYMMMDD.xlsx
eg- DataFile_2022Mar15.xlsx

Please help

Or — Tue, 15 Mar 2022 10:43:00 GMT

Let vFileName = 'YourPathHere\DataFile_' & date(today(),'YYYYMMDD' & '.xls';

If NOT isnull(FileSize('$(vFileName )') THEN

// Load stuff here

END IF

surajap123 — Tue, 15 Mar 2022 13:10:50 GMT

Thank you so much for your help. It solves my issue.

Just wondering if the latest file is not available, i want to pick Yesterday's file. How can i add that to the code?

Or — Tue, 15 Mar 2022 14:34:14 GMT

Add an ELSE section to your IF THEN block, set the vFileName to yesterday's file which would be today()-1, and then load that.