Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rpayn01215
Creator
Creator

Grabbing One File per Day in a Data Dump Folder

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

1 Solution

Accepted Solutions
Oleg_Troyansky
MVP & Luminary
MVP & Luminary

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!

View solution in original post

1 Reply
Oleg_Troyansky
MVP & Luminary
MVP & Luminary

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!

View solution in original post