I have a folder contain qvd for each data per month, for illustration is like this:
From the example above, we can see that there is two deleted qvd (Data_201503.qvd , Data_201504.qvd). My goal is to reload and recover the deleted qvd.
I have find the way to get the deleted qvd by compare it with the calendar table and put the missing YearMonth into variable, let's say the varible name is FileLoad. Varible FileLoad has a data like this 201503, 201504
At last I want to load the deleted qvd from the data source and store it into qvd, the problem is how can i load only the 201503 and 201504 value.
I've try using WILDMATCH like this:
from datasource where wildmatch(YearMonth, $(FileLoad))
But the performance is too bad and really slow. The question is are there another method to load script and compare with variable without using WILDMATCH function ?