Conditional Join

Question

Hello!

I am looking for some suggestions on what tool would be good for the following scenario:

I want to use a condition, if there is data on the left side of my join tool then send an email, if there is no data, either stop there or don't send the email . Any idea?

messi007 · Answer

@mzp,

A possible solution would be to only send the email on a successful run of a workflow and triggering an error if there are no data. Use the Count Records tool followed by the Message tool with the following configuration

Configure the workflow to cancel running if an error occurs - this can be done within Runtime setting of the workflow

Hope this helps!

Regards

DHB · Answer

Not sure I understand correctly but can you not just put an email tool on the left output or filter the left output to non-null email records?  Might need a visual to get a better idea.