Alteryx Designer Desktop Discussions

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

Error message when no records pulled through

Zoe_cross16
7 - Meteor

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!

5 REPLIES 5
Carlithian
11 - Bolide
11 - Bolide

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.


Happy Alteryxing
Zoe_cross16
7 - Meteor

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
11 - Bolide
11 - Bolide


Here you go ðŸ˜Š
No Record Test.png


Happy Alteryxing
Carlithian
11 - Bolide
11 - Bolide

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?  


Happy Alteryxing
Zoe_cross16
7 - Meteor

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

Labels
Top Solution Authors