We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

Is it possible to identify which column is blank in a formula IF "THEN" message?

wonka1234
9 - Comet

Hi,

 

I have a formula like so :

 

If (IsNull([Date)]) AND !IsNull([Status]))
OR (!IsNull([Date)]) AND IsNull([Status]))
then "ERROR, Only one of these two columns have a value."
else Null()
Endif

 

 

Instead of having a then message saying "ERROR" can I identify which column is causing the error. Ie  Something like: Column for XX is blank while Column for XX has a value.

 

 

Any advice here

2 REPLIES 2
gabrielvilella
14 - Magnetar

Maybe this?

IF (IsNull([Date)]) AND !IsNull([Status]))
THEN "Date null"
ELSEIF !IsNull([Date)] AND IsNull([Status])
THEN "Status null"
ELSE Null()
ENDIF
PanPP
Alteryx
Alteryx

Hi @wonka1234 

 

Another option you have when a column is not null and is empty is to utilize the IsEmpty([Date]) formula which looks for the blank value and can replace that with any value, etc.

 

You can utilize the IsNull option if the columns are null.

 

 

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

 

 

Labels