How to disable a tool container based on DateTime - Scheduled workflow

Hello!

I am facing a weird issue here. I have a workflow that i have saved on the server. If I run it manually from the server Gallery then it works as intended. But the same job "fails" when I run it on a schedule.

workflow issue - datetime.png

What I want is the workflow to either go through container 1 or container 2. Below is the formula I use in the action tools but the true/false is opposite. So if datetimenow is between 08:00 and 23:59 then the top container is enabled and the bottom one is disabled. If the date is not in that range, then the top container is disabled and the bottom on is enabled.

if DateTimeNow() >= ToDateTime(left(datetimenow(),10)+" 08:00:00")
and DateTimeNow() <= ToDateTime(left(datetimenow(),10)+" 23:59:59")
then "True" else "False" endif

And this date check only works if I run it manually from the gallery. As you can see from the screenshots, the manual run outputs only 1 record, while the scheduled one outputs 2 records.

The reason I need this to work is that we are not allowed to run ETL jobs outside the time range, but Alteryx server cannot schedule "run every hour, every day, but only between 08:00 and 23:59". So I want to schedule the workflow to run every hour, but if the datetime is out of range, then the whole workflow is disable.

Here is a video of the workflow behaviour:

Gallery

Schedule

Accepted answers

All comments

joshuaburkhow

I think what you need is to use the detour tools https://help.alteryx.com/current/designer/detour-tool

Which you could build logic that goes to left/right actions.

Or you can use most interface tools into the 'condition' tool https://help.alteryx.com/current/designer/condition-tool and then based on the condition you can enable/disable a container or containers

JustinBabbitt

Hi @jensroy

You could probably simplify this using a detour tool. It would look something like the image below.

Notice that the Text Box tool is hidden, so it won't show up in the interface.

Another way to use the Detour is without a Detour End, which would allow you to pick one set of actions if it is within the timeframe you specify and another action (or inaction) when it is outside of the timeframe.

I hope this is helpful.

Justin

jensroy

I wish I could use the detour tool. But the thing is, I need to disable reading from any data source if datetimenow() is out or range.

The condition tool outputs True or False. The outcome of my Action Tool is also True or False. I just tested with the Condition tool as well.

The True output connects to Tool Container 1, and enables it if the datetimenow() is in range.

The False output connects to Tool Container 2, and enables it if the datetimenow() is out range.

Default state is that both tool containers are disabled.

Result:

If I run it manually, then I get the desired outcome.

If i run it by schedule (schedule once) then I get the exact same error as before. The date condition is not evaluated at all, so both containers remained disabled.

So the server behave differently if a named user is manually pressing run, compared to if the analytical app is ran automatically from the scheduler 😞

JustinBabbitt

That is interesting.

One thing to consider when testing/trying out options in the Scheduler is that if you schedule a workflow or app, then make changes to that app, you must Update the workflow OR Delete then reschedule the app using the 'new' version for the app changes to be recognized.

Another thing is you may want to try to save the workflow/app as a package (yxzp file) and schedule the package. If you don't know how to do that, go to Options: Export Workflow.

Thanks,

Justin Babbitt

jensroy

Yes, puzzles are fun!

I tried to upload a new version to the Gallery, but that also had the same behavior. Works with manuel run but not with schedule.

I know how to export it, but how can I schedule a yxzp? I would need to open the package, and what I schedule would then be a a workflow or an app?

David-Carnes

I have solved this problem by putting the main logic into a Batch macro then using the Control Parameter to Delete Tool from Workflow the Container that has the stuff I don't want to run. Here's my real life example.

(The use case is sending a REST API call to SendGrid in which I don't know if there will be attachments to said email)

Inside the supportng macro that is creating the JSON for the attachments part. I need something to come out the macro regardless of input.

The Control Parameter takes a Bool and deletes one or the other Container. Here, a True deletes the bottom Container and a False, the top one.

Inside the SendGrid macro that the users interact with. In this case I count the incoming records then convert the interger into a Bool by changing the datatype. A zero translates into False and any number above that becomes True.

Hope this helps!

Best,

David

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703