Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Error message for Empty field

Tid14
8 - Asteroid

Hi, I am working on a workflow where I need to error out the message when the [Sum Original amount] is not equal to zero or when its empty field. The 0 amount error I have already done but not sure how to do it is a blank field as shown in attached file.

Any help on this.

 

Note: I don't want to put the Count tool and then error it out..

 

Thanks in Advance :)

 

 

error tool.PNG

1 REPLY 1
FinnCharlton
13 - Pulsar

Hi @Tid14 , you can use the Test tool for this. Select the test type 'Record Count Matches Specific Value' and choose the value 1. As you are summarising to one group, you should always have one record. This configuration will throw an error if there are no records.

Screenshot 2023-07-17 110958.png

Hope this helps!

Labels