Output Message when input has no records

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

Output

Accepted answers

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😀👍

All comments

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

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😀👍

Use a MESSAGE tool!

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

you can warn, error or even stop the workflow.

cheers,

Mark

Thanks for you help

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703