nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Expression

Accepted answers

Blake

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.

All comments

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.

Alteryx.png

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15910

binu_acs 15783

MarqueeCrew 13710

apathetichell 13703