Unique tool errors when there are no records

cowannbell

I have an analytic app and depending on what is entered it could result in no records.

The last thing the app does is remove dup rows.  When there are no records returned, it will error out.

I know this should be simple but for some reason I can't figure it out.

What I want to do is to say if there are no records display an custom error message if not then go on through to the unique tool and complete the workflow.

Any ideas?

TheOC

hey @cowannbell 

You can create custom errors like that with the Test tool, or message tool.

What i would suggest, is prior to your unique tool, a Count records tool. Then, do a test as to whether the count of records is 0.

This would look like:

You can also set in runtime settings to cancel the workflow on error:

I've attached this as an example!

Hope this helps,
TheOC

cowannbell.yxmd