Error message in Join tool

[vishtrack]

Hi Folks,

I am trying to build a workflow for users using the Join tool and the ask from users is as below-

- If the Join tool has Left Un-joined records then display an error message "User data not available for the records"

How do I achieve this? Thanks in advance.

[apathetichell]

attach a message tool to the left join exit and have it display your message before the first record.

[rzdodson]

@vishtrack you can attach a Message tool (Developer palette) after the L anchor of your Join tool. From here, you are going to want tot change your "When to Send Message" settings to "Before First Record". Afterwards, you can adjust your Message Type and Message Priority settings accordingly. Then, finally, you are going to want to put your "User data not available" message in quotes in the "Message Expression" field.

The message will show up in your Output log for you.

See attached workflow as an example. 

Edit: if you need your workflow to error out when there are records falling out of that L anchor, simply change your Message Type settings to "Error". The workflow will operate the same way, but it'll show your "User data not available for records" message as an actual error message in your Output log.