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. TypeLabel CodeAppleAAppleBAppleCAppleFOrangeAOrangeBOrangeCPearAPearBPearCPearD The desire outcome would be TypeLabel CodeAppleAAppleBAppleCAppleFOrangeAOrangeBOrangeCPearAPearB

How to Filter out with certain value

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

Workflow

Accepted answers

jrlindem

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

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

All comments

jrlindem

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

@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.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335