community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Filter using OR

Meteoroid
I am trying to select only those records that have a certain attribute. As long as the record has one of multiple forms of this attribute, it should be included, otherwise it should be excluded. The attribute is Int. My condition on the filter looks something like this:

(field name)==xxx||yyy||zzz

This isn't working. It is returning all records in teh true stream and none in the false stream.
Founder
Founder
You can use a IN statement:

[Field1] IN (5,6,8)

That does exactly what you are asking for.  
Highlighted
Founder
Founder
And just to add 1 more detail:  If you want to use the || or OR syntax (OR and || are synonyms) , you need to specifiy the field name multiple times:

[field]==a OR [field]==b OR ...
Aurora
Aurora

Hey @raddi

 

Are you OK to mark @Ned 's solution as 'Solved"?   That way, this can contribute to the body of knowledge that folks can search for worked solutions.

 

Community Admins - if @raddi is not able to get to this in a week or two - would you mind marking this as solved?

 

Thank you

Sean

Meteor

Is this still applicable? I tried both solutions but it did not work. 

Quasar

Hi @ckirgiz!

 

Try:

[Field1] IN ("xxx","yyy","zzz")

 

I also attached sample workflow. Please let us know if this works for you.

Meteor

Thank you so much @ddiesel! It worked very well.

Quasar

You're welcome! Glad it worked for you!

Labels