Using Filter Tool Contains with Multiple Criteria

[malafollette]

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

[AlteryxUserFL]

You can use an and to add more then one. 

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

[malafollette]

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.

[Blake · Accepted solution]

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

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. 

[AlteryxUserFL]

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

[Blake]

@AlteryxUserFL 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.