Output Message when input has no records

[EJ_Alt]

Hi Alteryx family,

Need some help here

How can I create a formula that can output a message when the a tool produces no records e.g. see captions, the input too has 4 records. What if the input tool is blank, no records just the header (team, score and player)? I want the formula to output a message saying, “there are no teams”.  

Thanks

EJ

Workflow is this

Input tool

Formula Tool is

Output

[atcodedog05]

Hi @EJ_Alt ,

You can use count record to count the number of records.

https://help.alteryx.com/current/designer/count-records-tool

Hope this was helpful

If this post helps you please mark it as solution. And give a like if you dont mind😀👍

Let me try to prep a workflow

[atcodedog05 · Accepted solution]

Hi @EJ_Alt ,

This is an interesting scenario.

Here is a workflow for the task.

Scenario - 1

Input:

Output:

Scenario - 2

Input:

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind😀👍

[MarqueeCrew]

@EJ_Alt  ,

Use a MESSAGE tool!

https://help.alteryx.com/current/designer/message-tool 

you can warn, error or even stop the workflow. 

cheers,

Mark

[EJ_Alt]

Thanks for you help

[atcodedog05]

Hi @EJ_Alt 

Intresting scenario you proposed there.

Happy to help 🙂

Cheers and Happy Analysing 😀