Load the most recent file into Qlikview based upon its last modified date

Wed, 12 Oct 2016 19:39:46 GMT

I am attempting to load only the most recent file from a folder into Qlikview based upon the date that it was placed in the folder. Below is my current data. Even with the where statement, it still scans in every file from the folder. Any idea on how to make this work? Thank you!

INVOICE_HEADER_2016_Oct_12_060501.qvd is the file format.

Invoice_Header:
LOAD distinct *
from \\HACQVPROD\QVProd\PRODUCTION\DATA\INVOICES\Daily\Invoice_HDR.qvd(qvd);

concatenate
add Load distinct *
FROM \\HACQVPROD\QVProd\PRODUCTION\DATA\INVOICES\INVOICE_HEADER_2016*.qvd(qvd)
where Date(FileTime(), 'DD/MM/YYYY') >= Today() -1;

Invoice_Lines:
load distinct *
from \\HACQVPROD\QVProd\PRODUCTION\DATA\INVOICES\Daily\Invoice_LIN.qvd(qvd);

concatenate
add Load distinct *
FROM \\HACQVPROD\QVProd\PRODUCTION\DATA\INVOICE LINES\INVOICE_LINES_2016*.qvd(qvd)
where Date(FileTime(), 'DD/MM/YYYY') >= Today() -1;

Re: Load the most recent file into Qlikview based upon its last modified date

Mon, 17 Oct 2016 13:37:49 GMT

Does anyone know what I am doing incorrect or can anyone provide a link to a possible solution?

topic Load the most recent file into Qlikview based upon its last modified date in QlikView

Load the most recent file into Qlikview based upon its last modified date

Re: Load the most recent file into Qlikview based upon its last modified date