Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

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

wonka1234
10 - Fireball

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 Alumni (Retired)

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