community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Stop The Workflow When there is a Data Error

Highlighted

Hello There

I need to stop the workflow further from running when there is a data error in between of tools

I need to check the incoming data for ex. if any column has nulls then don’t process any rows including valid and stop the execution of workflow 

Can you give me suggestion if any workaround?

Alteryx Certified Partner
Alteryx Certified Partner

@s_pichaipillai, The message tool should be able to help you out here, you can create an error when a particular expression is met.

Thanks Joe

Well, i already tried that too but i dont see stop the flow and i see few options but nothing helped me

see the below one option i used but it skips that rows and send the valid rows to next tool :( not stoping the execution 

Message.PNG

Alteryx Certified Partner
Alteryx Certified Partner

Strange, my example attached stops the workflow.

 

Message Pic.JPG

 

Could you send your example if you cannot get it to work?

i think you are using 10.0 and i am using 9.5 still

can that be a reason :)

see the one i attached for 9.5

Alteryx Alumni (Retired)
Have you tried looking at the Test tool, maybe in conjunction with the Field Summary (use the top, tabular output) to look for unwanted field contents?

Another option is to use the Summarize tool to count nulls, followed by a filter and then Test tool.




--

Scott Lutz
Solutions Engineer

Alteryx, Inc
359 Goswell Road, London, EC1V 7JL
Mobile: +44 7522 961835
LinkedIn| Skype | Email | Twitter
Alteryx Certified Partner
Alteryx Certified Partner

Apologies, I had set my workflow up incorrectly and forgotten to add an expression! The Help states that: Note - All records are passed through regardless if the expression is true or false.

 

I would suggest trying @ScottL suggestion with the Test tool. Let us know how you get on.

 

 

Joe,

Nope , Test tool did not help me as i dont see any ourput to it

Am i miising something?

Alteryx Certified Partner
Alteryx Certified Partner

Attached is a sample workflow to STOP if you receive a NULL value.

 

1. SET RUNTIME configuration to Cancel Workflow on Error.

2. USE Block Until Done to keep other processes from running

2. Create a TEST for your condition.

 

I've added a macro that transposes all of the data and automates a failure with the presence of a NULL value.  You can use it as a test (output #1 from Block Until Done).  The macro requires a RecordID field.

 

Null Check.png

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Alteryx
Alteryx

Here is my (somewhat ugly) workaround

 

Parent_ErrorChecker.png

I check for the condition using a filter; then count how many rows fail and attach that count to each row of my data.  Then I only allow all the data through if the count is zero.

 

It could be wrapped as a macro to make it cleaner.

Adam Riley
Principal Software Engineer
Tech Lead Core Engines, Alteryx
Labels