Error: Parse Error in the IF ELSE

Question

Hi Geeks,

I did check in earlier posts for similar issue

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Error-Parse-Error-at-char-n-Invalid-type-in-operator-lt-gt/ta-p/773363

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Error-Parse-Error-at-char-n-Malformed-If-Statement/ta-p/836906

But still not clear what's wrong with this?

IF [PROD_LN] = 'M' then 'MILK'
ELSE IF [PROD_LN] = 'SM' then 'Skimmed Milk'
ELSE IF [INVENTORY]= 'Dress' AND [CODE]!='Men Dress' then 'Cloths'
ELSE IF [LOC_NAME] = 'NY' and [PRODUCT] in ('3','4') then 'NY TextTiles'
ELSE 'NON_Unit' 
ENDIF

BS_THE_ANALYST · Accepted Answer

May seem trivial but do you have a space between ELSE and IF? It should be one word ELSEIF, I'm pretty sure!: See picture directly from formula bar. That could be what the fuss is

Felipe_Ribeir0 · Accepted Answer

@stevelogue1980 ,  i believe that @BS_THE_ANALYST is correct.