Cannot use the "ELSEIF" operator

[AkisM]

Every time I try to type or even copy paste the word elseif into a formula to use it, alteryx only detects the part "else" and "if" is interpreted as wrong syntax, despite the fact that it's 1 word. What's up with that?

The formula I'm trying to write would look something like this:

IF [Description]='something' THEN [Type]='X' ELSEIF Contains([Description], 'Dumbbell') OR Contains([Description], 'Bar') THEN [Type]='Sport' else [type] ENDIF

But as I said above it doesn't let me use elseif and I'm trying to understand why.

[LordNeilLord · Accepted solution]

Hey @AkisM 

You're syntax isn't quite right...try this:

IF [Description]='something' THEN [Type]='X' ELSEIF Contains([Description], 'Dumbbell') OR Contains([Description], 'Bar') THEN [Type]='Sport' else [type] ENDIF

Neil

[grazitti_sapna]

hi @AkisM,

Try this workflow.

Thanks.