How to stop the workflow on the basis of condition.

Question

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.

ashleyharvey19 · Answer

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.

WirkKarl · Answer

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.

flying008 · Answer

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.