Error message when no records pulled through
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Labels:
- Error Message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here you go 😊
Happy Alteryxing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It is now pulling through the count as 0. Thank you for your solution!
