Malformed If Statement (Expression #1)

Question

I cannot seem to fix this in Alteryx

Screenshot 2026-03-30 165742.jpg

ChrisTX · Answer

Use a space before and after ELSE and a space before ENDIF.

Also, you are not using the right syntax for Contains.

See https://help.alteryx.com/current/en/designer/functions/string-functions.html#id625104

Try the IN operator.  See https://help.alteryx.com/current/en/designer/functions/operators.html#id624281

Also consider using the UpperCase function like this:

IF UpperCase([System Role]) IN ('WAREHOUSE MANAGER', 'MASTER DATA ANALYST', 'INVENTORY COORDINATOR')
THEN "MTD MOVE - PETERBOROUGH"
ELSE [Release]
ENDIF

Chris

OTrieger · Answer

@kgnott46 
Do you see that the ENDIF is in Black, it is not recognizing it. Delete the ) before the ENDIF