IF with a string and empty field

[AAA2017]

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

[sjm · Accepted solution]

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]

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]

Rookie mistake :) 

Thanks a lot guys.

[JollyRodgers]

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