Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

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

IF with a string and empty field

AAA2017
5 - Atom

Hello,

 

Basic function but I'm a new user so I'm having a little trouble.

 

I'd like to do an IF function as below with the attached file.

 

IF ([productCode])=([Product Code]) THEN "Perfect" ELSEIF ([GID])=([GID2]) THEN "Non-perfect" ELSE "Not in Catwalk" ENDIF

When I do it alteryx gives me an Error: Formula (37): The field "" is not contained in the record. (Expression #1)

 

Could you please help ?

 

Thanks a lot.

 

Dri

4 REPLIES 4
sjm
8 - Asteroid

Did you name the new Output Column?

 

If not, try this: Click Select Column (right above where you wrote the formula), click Add Column, and give it a name.

NicoleJohnson
ACE Emeritus
ACE Emeritus
You may also need another EndIf at the end - need one for every If as long as you are using If/EndIf method vs. IIF() method for your formula :)

Cheers!
NJ
AAA2017
5 - Atom

Rookie mistake :) 

 

Thanks a lot guys.

JollyRodgers
5 - Atom

I feel ya there. Glad my mysterious error is gone!

Labels
Top Solution Authors