Invalid Operator == and/or Parse error for ELSEIF function

Hello, I've read through all the posts I could find on the issue I'll discuss below, but none of the solutions work. I am trying to run an ELSEIF function to consolidate different names of products into an overall umbrella (see screenshots), however I am running into an error whenever I try adding the ENDIF portion of the function where it makes the function black text up to a certain point. Here are the solutions I've tried:

- closing Alteryx and reopening

- insuring all fields are the same type (VW String)

- split into separate formulas to reduce character cound, but ran into the same issue

- checked all booleans to insure no extra spaces around them

- cleansed the data several times

I'm at a bit of a loss on what else to try as the data seems clean and I feel like I've double checked all I can. Thanks for the extra set of eyes.

2024-12-03_17-28-06.PNG

2024-12-03_17-27-49.PNG

Designer Cloud

Accepted answers

Deano478

@jb09608 I believe what @Qiu was saying was to try and expression like so

IF [Capture Products1] = "Advantage 7 Stock" THEN "Advantage 7"
ELSEIF [Capture Products1] IN ("Advantage Stock", "Advantage+&reg; Stock", "Advantage+&trade;") THEN "Advantage (AA and AA+)"
ELSEIF [Capture Products1] = "Benefit Control Stock" THEN "Benefit Control"
ELSE ""
ENDIF

All comments

Qiu

@jb09608
You should use the In operator

Value IN Operators
Value IN (...) - Keyword
IN (): (Test Value in List) Determines if a given value matches any value in a subquery or a list.

apathetichell

I have discussed this in previous threads. It looks like you have [field]='value1' or 'value2' --- this is incorrect. it is a boolean expression which reads [field]='value' or (boolean field if value2 is boolean) --- not [field]='value1' or [field]='value2' which presumably you want. the correct way is to use an In statement as @Qiu correclty points out. The syntax is [field] in ('value1','value2'...'valueN')

jb09608

Can either of you provide an example including my data? I'm not familiar with IN operator.

Qiu

@jb09608
I can take a look if you could share some workflow or sample data.

apathetichell

@Qiu is too nice here --- but too summarize you are asking us to transcribe your screen grab of your data because you don't want to upload your data - but you want us to fix things for you?

jb09608

I'm by no means asking you to fix things for me. I was asking for a brief example using a portion of my data, so that I could understand how to use that function as when you go to alteryx's page it says very little and no example is provided.

IF [Capture Products1]="Advantage 7 Stock" THEN "Advantage 7"

ELSEIF ([Capture Products1]=("Advantage Stock" OR "Advantage+® Stock" OR " Advantage+™")) THEN "Advantage (AA and AA+)

ELSEIF [Capture Products1]="Benefit Control Stock" THEN "Benefit Control"

Deano478

@jb09608 I believe what @Qiu was saying was to try and expression like so

IF [Capture Products1] = "Advantage 7 Stock" THEN "Advantage 7"
ELSEIF [Capture Products1] IN ("Advantage Stock", "Advantage+&reg; Stock", "Advantage+&trade;") THEN "Advantage (AA and AA+)"
ELSEIF [Capture Products1] = "Benefit Control Stock" THEN "Benefit Control"
ELSE ""
ENDIF

jb09608

This worked perfectly - thank you for the help ya'll!

Qiu

@Deano478 @apathetichell
Thank you for sorting this out. 😁

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280