topic Re: Only 1 time Reload per Day in QlikView

Only 1 time Reload per Day

munna1317 — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

There is problem in my Incremental, It should Reload 2nd of every month only one Time. How we can restrict that condition to Satisfy in Incremental.

Please Suggest any Ideas .

Thanks And Regards ,

Harish

Re: Only 1 time Reload per Day

jelle_vervloess1 — Wed, 04 Oct 2017 10:50:24 GMT

hi harish

can you give some more explenation please,Do you mean the load should only execute at the second of the month or do you have duplicate data?

if it is the first option you should be able to specify that in your qmc under tasks.

when there is duplicate data you have to give me a better explanation.

Re: Only 1 time Reload per Day

Anonymous — Wed, 04 Oct 2017 11:09:30 GMT

Hi Harish,

If you use the script to reload data and store it in QVD-files you and you can not find the reload option you need in the reload options you can always add something like below at the beginning of your reload script:

SET v_date= 2;

IF Day(today()) >$(v_date) then ;

exit script;

end if;

If you reload the script now (fe daily) it will stop the reload every day except the 2nd of every month.

Dennis.