Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!
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!