Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Stop flow if count > 0

7 - Meteor

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.

 

G_WOLAK_0-1574185338302.png

 

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

 

G_WOLAK_1-1574185388361.png

 

Here is the configuration of the test tool.

 

G_WOLAK_3-1574185440958.png

 

G_WOLAK_5-1574185513004.png

 

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.

14 - Magnetar

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!

7 - Meteor

Thanks!  That worked. 

 

Labels