Stopping workflow using Test Tool

Hi Everyone,

I have created a workflow and used a test tool to stop the workflow processing if error pops up in the test tool to check Count(Records) <= 0 from Inner Join and I have used the Runtime to enable the cancel workflow on errors checkbox. I could see the workflow processing even after the test tool fails. The way I tested this is, once after the error comes in Test Tool, I clicked the output of Union tool and I am able to see values populated, but I was expecting it not to retun any value just becasue the workflow has to stop process before the Union. Please find the below screenshot of workflow created. Could anyone please help me in resolving this issue?

Test Tool.PNG

Data Investigation

Accepted answers

TonyA

One approach would be to use blocking tools and make sure your workflow is set to "Cancel Running Workflow on Error" in the workflows configuration pane under "Runtime." Simple example attached.

EDIT: There is a discussion about this topic with other options here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Stop-Workflow-on-Test-Tool-fail-Force-Test-Tool-to-run-first/td-p/384127

ErrorTest.yxmd

All comments

TonyA

One approach would be to use blocking tools and make sure your workflow is set to "Cancel Running Workflow on Error" in the workflows configuration pane under "Runtime." Simple example attached.

EDIT: There is a discussion about this topic with other options here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Stop-Workflow-on-Test-Tool-fail-Force-Test-Tool-to-run-first/td-p/384127

ErrorTest.yxmd

TonyA

Hi @msivakumar,

If the last response resolves your problem, please mark it as a solution so that others will be able to find it if they have a similar issue. If this hasn't answered your question, can you let us know why so we can help?

msivakumar

Thanks Tony, that worked.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703