Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
rpayn01215
Contributor

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
MVP & Luminary
MVP & Luminary

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

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
MVP & Luminary
MVP & Luminary

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

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