Error message when no records pulled through

[Zoe_cross16]

Hi, 

I have a workflow that will be scheduled on the gallery which I would like to only run the 2nd half of the workflow if there are records being passed through as otherwise a messy error occurs. I am happy to settle on there just being a different error message that says 'error- there are no records being passed through' if this is not possible. I know the new version of Alteryx has a feature allowing containers to be disabled if there are no records passing through however I don't have this new version yet so am looking for a work around for the time-being. My current approach is to use a count records tool followed by a message tool however I'm not sure how to configure it correctly.

Any advice would be much appreciated, thank you!

[Carlithian]

Using a similar method to what you have described you would be able to use the Test Tool, setting it up to error is there are no records after you count. Then change the workflow settings to end workflow on error. This should prevent it running and that point, and you can have an error message highlighting why.

[Zoe_cross16]

When I use the count records when there are no records instead of producing a count of 0 there is no row at all. How can I write an expression for this in the test tool?

[Carlithian · Accepted solution]

Here you go 😊

[Carlithian]

Sorry @Zoe_cross16  just reread your message, you say the output of the Count Records tool isn't showing 0 when there are no records going into it?  

[Zoe_cross16]

It is now pulling through the count as 0. Thank you for your solution!