How to stop the workflow on the basis of condition.

[vaibhav3339]

I have created one workflow which has multiple batch macros.

This workflow is scheduled to run daily from Mon-Fri.

I wanted to put in the condition where I want this workflow to stop where is there is any holiday.

I have excel file which contains holiday dates.

I want to stop the workflow processing when there is any holiday.

How can I achieve this please help.

[davidskaife]

Hi @vaibhav3339 

Two options spring to mind, first using the Test Tool and cancelling the workflow - https://knowledge.alteryx.com/index/s/article/Stop-workflow-on-a-condition-1583459852794 

Second option, use a Filter tool to check the date, and only process data if the date is true, otherwise do nothing.

[caltang]

You need to have a list of holidays on hand in a mapping file, and build it to your workflow to just either detour or error out.

[Dhrish]

Hi @vaibhav3339 

I mostly use the message tool to create a customized error message based on the condition which in turn stops the workflow. Steps are similar to the link that @davidskaife provided.

[flying008]

Hi, @vaibhav3339 

If you are using a version greater than v2023.1 and have activated AMP mode, you can use the Control Container tool to achieve this requirement.

[WirkKarl]

You can handle this by using a Filter tool at the start of your workflow. Bring in your Excel file with the holiday dates, and then check if today’s date (or the date the workflow is processing) matches any of the holiday dates. If it does, you can stop the workflow from continuing by using a Detour tool or simply preventing downstream macros from running. This way, your workflow will only process when it’s not a holiday.

[ashleyharvey19]

Conditional stops in Alteryx can be tricky, especially when the workflow needs to halt without triggering long chains of tools afterward. I like routing the logic through a Filter or Test tool and sending the failing branch into a Message tool set to Error, since that forces the run to stop cleanly. It helps me avoid partial outputs and keeps the workflow behavior predictable.