topic Re: Cannot use the "ELSEIF" operator in Alteryx Designer Desktop Discussions

Cannot use the "ELSEIF" operator

AkisM — Fri, 05 Jul 2019 05:37:59 GMT

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.

Re: Cannot use the "ELSEIF" operator

LordNeilLord — Fri, 05 Jul 2019 06:45:13 GMT

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

Re: Cannot use the "ELSEIF" operator

grazitti_sapna — Fri, 05 Jul 2019 06:56:59 GMT

hi @AkisM,

Try this workflow.

Thanks.