We have a folder where we get file every day. Each file is having date as below.. some of the filenames are shown below.
Now our client’s requirement is that file having date 10th of every month should be loaded, as the forecast calculation is based on 10th of every month to 9th of the next month.
So, on March 10th the file FileName_10032014 should be loaded and it will be keep loaded until 10th April. Now on April 10thFileName_10042014 will be loaded. File having other dates are being used in other apps and should not be loaded at all.
Let me know how can we achieve this in QlikView Script?
I need the dynamic solution and don’t want to update the filename 10th of every month.