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

[jb09608]

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. 

[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?