How to Filter out with certain value

[Apple_Orange]

Hi Community,

We have many Label codes for each product type. For Pear, I only need keep the record for Label Code "A" and "B". For the rest of Type, no need to filter out any Label code. Could Alteryx help.

Type	Label Code
Apple	A
Apple	B
Apple	C
Apple	F
Orange	A
Orange	B
Orange	C
Pear	A
Pear	B
Pear	C
Pear	D

The desire outcome would be

Type	Label Code
Apple	A
Apple	B
Apple	C
Apple	F
Orange	A
Orange	B
Orange	C
Pear	A
Pear	B

[jrlindem · Accepted solution]

Here you go:

Follow the [F]alse path once done.

Inverse logic is always a little mind-bending, but you identify what you want to carve out, then just follow the false path of the filter tool.  Hope that helps, -Jay

[binu_acs · Accepted solution]

@jrlindem one more filter condition to get the result in True-anchor

[dreldrel]

I believe @jrlindem and @binu_acs have shared great solutions. One practical tip you can use is to add a data cleaning tool before the filter, as the values may contain leading/trailing spaces or different cases if they come from users. Data cleaning tools can easily handle those cases

[jrlindem]

Thank you, @dreldrel for the response, however, I would caution against the use of the data-cleanse tool due to its tendency to slow down workflows and clog up memory.  The general assumption for this solution is that the author has already tailored their workflow to account for general cleansing activities but just needs help with the logical components, applied against their dummy-data.

-Jay

[Apple_Orange]

Thanks so much for the solution.