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

Multiple IsEmpty Statements

Adam_B
8 - Asteroid

Hello all, 

I have a data set with with Columns named Category Level 2, Category Level 3, and Category Level 4.  Some of the data those columns is BLANK.  So I would like to replace the BLANK with "UNKNOWN".  

 

I have tried this formula:

IF
!IsEmpty([Category Level 2]) THEN [Category Level 2]
ELSEIF !IsEmpty([Category Level 3]) THEN [Category Level 3]
ELSEIF !IsEmpty([Category Level 4]) THEN [Category Level 4] ELSE
"Unknown"
ENDIF

 

However, it is not working, I am receiving this error: 

Adam_B_0-1613512047979.png

Any help would be appreciated. 

Thanks, 

Adam 

3 REPLIES 3
Emil_Kos
17 - Castor
17 - Castor

Hi @Adam_B,

 

You need to pick a column name. Probably you forgot to do that. 

 

Emil_Kos_0-1613512188652.png

 

Qiu
20 - Arcturus
20 - Arcturus

@Adam_B 

Just as @Emil_Kos pointed out, the new column name is not set.

0217-1.PNG0217-2.PNG

Adam_B
8 - Asteroid

Thank you!

Labels