Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Using Filter Tool Contains with Multiple Criteria

Highlighted
6 - Meteoroid

I am trying to pull from a list of things that I need to filter on two specific descriptions, but I am unsure how to write the Custom Filter expression. For example in another workflow I did, Contains([DESCRIPTION], "Zero Beta"). Now I need to filter on Zero

Highlighted
11 - Bolide

You can use an and to add more then one. 

Contains([DESCRIPTION], "Zero Beta") and Contains([DESCRIPTION 2], "Zero")

 

Highlighted
6 - Meteoroid

Is this how you would write it if those are the two things I need to filter on at one time? I'm attaching picture below.

Alteryx Partner

You should use "or" in this case instead of "and" 

 

Blake_0-1581616274735.png

 

 

If this did what you were looking for, please mark this as solved so others in the community can leverage this answer in the future. 

Highlighted
11 - Bolide

Yes, you can switch the and to an or if  need also  

Highlighted
Alteryx Partner

@DrewDavis I read the first question incorrectly and looked at the screenshot that @malafollette posted in response to your answer. 

 

Drew's answer is correct if you are looking at two different fields and need both to match the criteria. My answer is correct if you are looking at one field and are looking to filter for either of the criteria. 

Labels