Filter Tool help - excluding multiple factors

Hi again.

I have 4 program types in my data set. I only want to look at 2 of them. What is the best way to accomplish this?

Should I use one filter to exclude one of the program types then an additional filter to exclude the other program type I don't need? Surely there is a way to have one filter tool that says "I only want to look at X and Y program types".

Thoughts?

Help

Accepted answers

Simha

@skeen503979 , You can use OR clause in the same filter tool to accomplish this. Hope this helps.

OrFilter.yxmd

All comments

Simha

@skeen503979 , You can use OR clause in the same filter tool to accomplish this. Hope this helps.

OrFilter.yxmd

T_Willins

Hi @skeen503979,

The approach @Simha is correct. The Filter tool allows for Boolean expressions as well as even more complex formulas. If you had multiple program types you had to filer for, a cleaner (read this as easier to edit) approach is to use the IN function. The formula in the Filter tool would be [Program Type] IN ("X","Y") This will return the same results as using an OR function.

Simha

Agree with @T_Willins. If you have more than 1 or 2 items to compare, IN operator is the best. Nevertheless, a single filter is enough to formulate the most complex conditions.

skeen503979

Thanks @Simha and @T_Willins. Those are helpful ideas. Really appreciate the community! #teamwork

swoodling

Hello All-

The top solution worked perfectly. What if you want to have it exclude multiple fields. I realize you can just grab the false side of the filter output but was curious how one would change the formula from IN ().

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703