Stop The Workflow When there is a Data Error

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?

Workflow

Preparation

Accepted answers

AdamR_AYX

Here is my (somewhat ugly) workaround

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.

Parent_ErrorChecker.yxmd

All comments

Joe_Lipski

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

s_pichaipillai

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

ScottL

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

MarqueeCrew

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

Community NULL Check.yxzp

AdamR_AYX

Here is my (somewhat ugly) workaround

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.

Parent_ErrorChecker.yxmd

s_pichaipillai

Hi Marquee i think this was developed on 10.0 Version . i will check this too thanks for your suggestion

AndyC

Great tip!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703