Stop Workflow if Condition Not Met and Message Error

[hellyars]

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

[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.

[Jonny · Accepted solution]

Hello @hellyars,

how about that?

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

Cheers!

[atcodedog05 · Accepted solution]

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 🙂

[hellyars]

@atcodedog05  Sorry for the delay.  This totally helps.  Thanks!

[hellyars]

@Jonny  Oh, that's interesting.  I like the use of the Block tool.  What is that macro?

[Jonny]

Nope is not a macro, it is a Developer's tool, as the Message tool as well.

If you can't see the Developer's tab, check this out: Solved: Not seeing the Developer's tab - Looking for dynam... - Alteryx Community

cheers!

[suryaveera]

Combine it with this and it will cancel the workflow: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Cancel-Running-Workflow-on-Error/td-p/...