This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
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".
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.
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 ().