Stop flow if count > 0

[G_WOLAK]

I have a flow which I would like to stop if there are any rows in one of my left joins. 

I found this posting which details exactly how to do just that. 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Stop-workflow-on-a-condition/ta-p/1...

However when I add this to my flow the condition fails no matter what I do.  Here is the portion of the flow.

Here you can see the result is the count equals zero.

Here is the configuration of the test tool.

I believe I've set this up so that if the first cell in field 'Count' is greater than 0 it should fail, but it is failing when it equals zero. 

I've confirmed the field is setup as an integer, and have tried numerous combinations with no change in result.

[Claje · Accepted solution]

Hi,

You've got your logic reversed.  The example in the post you linked is a workflow which will fail if the test returns 0 records.  If you change your test to [Count] = 0 that will correctly throw an error if the Count is any value other than 0.

Hope this helps!

[G_WOLAK]

Thanks!  That worked. 

[Suppu]

It is still updating the output .

How can I make it stop ? so the o/p is not updated

[G_WOLAK]

I'm not sure why, but when I uncheck the 'Use AMP Engine' the file does not output for me.

[MattLi]

Thanks for above methods.

I have a further question on top of this.

if there is a way we can stop a workflow if a macro within the workflow runs over than certain time threshold?

Essentially, we know how to stop workflow with a condition, but is there a tool within altreyx can calculate the runtime of a macro within a workflow?