Discussion Board for collaboration on QlikView Scripting.
why did you add this:
(qvd) Where Not(Exists(ExchangeDate)
at the end of your incremental load?
it doesnt seem right....
it looks like you are loading from the QVD only data that doesnt exist in the incremental load in in that case you will load nothing. you already took the max date as a variable and extracted only newer rates.
take that line out and i believe your problem will be solved.
I added that piece of code because Jonathan told me so.
See his reply on this topic of the 22nd of June.
I adjusted the code and will let it run tomorrow.
I will let you know how it went.
I think this is what happens when you try to reload twice a day.
Because he already has all the data for the current day.
Try to wait a day so that there is new data to reload.
Then your problem should be solved..
Worked like a charm. Is there any way to generate an error message that will say something like "Exchange rates are already up to date" instead of the "Table not Found" error?
I'm not using these currencies to combine with transactions.
You could try to make a loop so when there isn't a currency found for a specific day, you can let it look back one or more days, until he has found a currency.
But no idea how to actually do that.
Good luck with it!