Give Error Message if the join result it Empty

Hi,

I know there is message tool can be used for error message.

But how to give Error Message if the join result is empty. I mean if there are no rows come out from join tool. I cannot use message tool to set up an error message.

Anyone ideas?

Thank you.

Developer Tools

Dynamic Processing

Accepted answers

jdunkerley79

I would use a Record Count and Test Tool.

You can attach it to the Join and then verify that the value if not 0. Setting the Runtime settings of the Workflow allows you to cause it to stop on an error as well.

Simple sample attached with workflow set to abort on Error

Count and Test.yxmd

cbridges

You can attach multiple outputs to the join tool - like in the attached modification of @jdunkerley79 workflow.

So, if it had passed the test, the data would continue on through the select tools and you can do whatever you want to do with the data after that.

Count and Test2.yxzp

All comments

cbridges

How about trying a count records tool first, as in attached?

See message #11

No Join Message.yxzp

cbridges

Or are you wanting it to actually error out, not just give a message?

jdunkerley79

I would use a Record Count and Test Tool.

You can attach it to the Join and then verify that the value if not 0. Setting the Runtime settings of the Workflow allows you to cause it to stop on an error as well.