Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have QlikView with publisher and on the QMC:
I have a task that loads the delta to be executed business days, but I have another task that runs the historical and the delta on the 1st day of the month (they must be executed sequentially).
My problem is that If a business day is the 1st, both tasks will be executed and this can generate some errors.
Is there any way to schedule the delta on business days with the exception on the 1st of the month?
Thanks in advanced.
You can stop the reload of the script for delta APP using the networkdays() function as a if else condition
if networkways(today()) >1 then
Load *
From XYZ
Else
Exit script
Thanks Rupam, that's something I dindn't knew but the problem here is that the Delta Task has some other chained tasks that run in case of successful execution. The 'Exit script', results in a successful exectuion of the Delta tasks and this doesn't prevent the following tasks to be executed.
Do you have any idea on how to solve this?