Stop Workflow if Condition Not Met and Message Error

I need to start setting up QC check points in my workflows.

I need to check there are no empty fields for certain records (a tiny subset) do not contain null or empty values. I want a warning and ideally I want the workflow to stop.

In the scenario below, I need to know if any records with the S/N 9999999999 have any corresponding isempty() or isnull() values in the fields NAME and REGION.

I need an alert that stops the workflow and says this is why.

S/N	NAME	REGION
9999999999	MIKE	WEST
9999999999	SEAN	null()
9999999999	MARK	EAST
9999999999	CHASE	NORTH
9999999999		SOUTH

Help

Accepted answers

Jonny

Hello @hellyars,

how about that?

Let me know if this is what you are looking for.

Cheers!

Stop_Workflow_Jonny_input.yxmd

atcodedog05

Hi @hellyars

You definitely need message tool. Here is 2 approaches.

Approach 1:

In this approach even though this stops the flows, it stop the flow from the row on which error occurred. But the previous rows will still be passed.

Approach 2:

In this approach i am counting blanks and appending it to all rows. And in message tool i am checking is count >0 if yes no rows are passed forward.

Hope this helps 🙂

stop workflow.yxmd

All comments

mbarone

The Message tool should be able to accomplish this. You can connect your datastream and use full formula functionality within the configuration of the tool. Check out the Tool Mastery Index for it: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Message/ta-p/36308.