Exit script on day's specified in qvd

Erik6 — Wed, 22 Feb 2017 20:07:04 GMT

Hi,

My reload script is scheduled to run every workday. But it must not run on certain day's. These day's are specified in a qvd.

I've the feeling that I should use the exist() function, but I don't know how to solve this.

Re: Exit script on day's specified in qvd

Erik6 — Tue, 04 Apr 2017 15:10:09 GMT

I've found a solution:

Holidays:

LOAD
HolidayYear,
Concat(HolidayDate,',') as ListOfHolidays
FROM (qvd)
Where
HolidayYear =Year(Today())
Group By HolidayYear;

LET vCheck= Peek('ListOfHolidays',0,'Holidays');
LET vToday=Today()+0; //the +0 converts the date into a datenumber, quick/dirty.
DROP Table Holidays;

If Wildmatch($(vToday),$(vCheck))<>0 then
EXIT SCRIPT;
ELSE
//do your coding
ENDIF

topic Re: Exit script on day's specified in qvd in QlikView

Exit script on day's specified in qvd

Re: Exit script on day's specified in qvd