Multiple Conditions Filter

Hello Alteryx Community,

I am fairly new to the alteryx platform and am finding myself stuck on a particular filter request. To first explain, each row contains a key ID, that can have multiple values in another column (X). I need to filter a column with set values in one column (X), for example, "1111", "2222", "3333". However, after have done this, I then need to filter those unique ID's to also include values "010101", "020202" etc. in column (X). The issue is that, after I filter the very first time, it only leaves me with "1111", "2222", "3333" and their key ID which then I cannot find "010101", "020202" in column X because of the previous filter.

I need a filter basically that states; of those values "1111", "2222", "3333" in column (X), which results in filtered Key ID's, which of those Key IDs also have values "010101", "020202".

I hope this makes sense. I can provide additional details if necessary.

Datasets

Accepted answers

All comments

atcodedog05

Hi @tsilverman_

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

tsilverman_

As you can see in the attached workbook, there are Key ID's that are duplicated. Column [X] needs to satisfy the first condition of having either "1111", "2222", "3333" and also having "10101", "20202", "30303". I just want to keep the Key ID's that satisfy both conditions.

expworkbook1.xlsx

Qiu

@tsilverman_
Here is a bit different approach.
I think the using a mapping file for the cretirias should be more easy for maitenance.

0101-tsilverman_.yxmd

atcodedog05

Interesting approach @Qiu 🙂👍

binu_acs

@tsilverman_ Another approach, appreciate @atcodedog05 and @Qiu's approaches

MultipleConditionFiltetrs.yxmd

tsilverman_

Thank you,

After trialing this method I am getting a different result. My real data set, for the Key ID column, contains complex characters, letters and numbers. I used the data cleanse tool to eliminate whit space and special charaters so that it only contains letters and numbers. Having everything else equal, it seems that the final result produces unwanted "X" column numbers. Actually, it outputs ones that I did not even select at all. the "X" column also contains many numbers and letters as well as some rows have blank spaces. Do you believe this is an issue with the data set not formatting correctly?

Qiu

@tsilverman_
This error message indicates that you are having a data type mismatch at filter #20, which is not in the flow of @atcodedog05 .
Can you locate the filter#20, and check the data type before and after the "=".

you can Igore the two = signs, which is believed to be somehow internal operator of alteryx.

atcodedog05

Hi @tsilverman_

Try this method

Workflow:

Hope this helps : )

Multifilter.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15872

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703