Error: Parse Error in the IF ELSE

[stevelogue1980]

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...

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Error-Parse-Error-at-char-n-Malform...

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 solution]

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 solution]

@stevelogue1980 ,  i believe that @BS_THE_ANALYST is correct.

[BS_THE_ANALYST]

👀