Give Error Message if the join result it Empty

[Inactive User]

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.

[cbridges]

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

See message #11

[cbridges]

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

[jdunkerley79 · Accepted solution]

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

[Inactive User]

Hi Cbridges,

I tried the  count records tool.

The problem is that if I use this tool, then it will ignore all the other fields and only output the field count.

Thank you.

[Inactive User]

Hi jdunkerley79,

I tried the  count records tool.

The problem is that if I use this tool, then it will ignore all the other fields and only output the field count.

For example,  if there have records after the join, the count records tool will only give out the filed 'count'

[cbridges · Accepted solution]

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.

[Inactive User]

Thank you so much. It works!

[cbridges]

Glad to hear it!

[Aum]

This saves me time and headache! Thank you.