Using Filter Tool Contains with Multiple Criteria
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Expression
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can use an and to add more then one.
Contains([DESCRIPTION], "Zero Beta") and Contains([DESCRIPTION 2], "Zero")
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes, you can switch the and to an or if need also 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
