Grabbing One File per Day in a Data Dump Folder

Anonymous — Fri, 06 Feb 2015 00:15:56 GMT

Hey Qlikkers,

We're having to pull the 1st file for the day in a data dump folder. We're using the current syntax for the path to get all of the files:

...Common\SAPReports\Sales\SALESREPORT_****2015*.xls]

As you can see, they're specified by full date and time. But, we're currently only interested in 2015. Sometimes, the subsequent file dumped out for the day (often more than one file per day) won't contain a column or two from the first spreadsheet of the day. This is obviously an issue. Can someone please help me please grab just the files that are dumped between 3:00AM and 3:37AM for each day? I hope the below screenshot will clarify. There are other files other than spreadsheets in the below folder as well (FYI):

Your help is greatly appreciated.

Thanks,

Ron

Re: Grabbing One File per Day in a Data Dump Folder

Oleg_Troyansky — Fri, 06 Feb 2015 01:04:42 GMT

Ron,

obviously, you can't apply any advanced logic if you load all the files at once using a wildcard. You can, however, process the files one at a time, using the logic commonly called "DoDir". For example:

http://community.qlik.com/message/682083#682083

or search the community for the keyword "DoDir".

When you process files one at a time, you can test for various conditions, like whether the previous date is the same as the current date, etc...

cheers,

Oleg Troyansky

Check out my new book QlikView Your Business - available to pre-order on Amazon!

topic Grabbing One File per Day in a Data Dump Folder in QlikView

Grabbing One File per Day in a Data Dump Folder

Re: Grabbing One File per Day in a Data Dump Folder