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
Solved! Go to Solution.
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
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😀👍
@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
Thanks for you help