topic Re: Trying to exclude specific day in Qlik Automate

Trying to exclude specific day

elitianp — Mon, 08 Jan 2024 11:05:54 GMT

Hey there

i want to exclude Saturdays from my loading scheduled

i try to use condition at the start

if [date] Doesn't equal Sat

i need to edit the date formula i get 3 rows

Date* : (i tried using Today or now

Output format: (in my case it's D)

Input format: ??????

Can someone explain how to use it or if there's any other way to solve this ?

thanks in advance

Re: Trying to exclude specific day

Or — Mon, 08 Jan 2024 15:46:46 GMT

I wasn't able to make heads and tails of your post, but if you want a scheduled task to run every day of the week except Saturday, you would use 1-6 in the fourth position. A similar case is described in the documentation:

Re: Trying to exclude specific day

elitianp — Sun, 14 Jan 2024 20:17:40 GMT

thank's i will try that also

Re: Trying to exclude specific day

rajjul — Mon, 15 Jan 2024 04:08:34 GMT

You can also try other ways like this

Run the task every day

in the source code of task execution check if it is sat then exit with-out further executing code. if not sat then execute complete task.