Multiple Conditions Filter

[tsilverman_]

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. 

[tsilverman_]

I separated the conditions because when I tried to combine them into one manual filter code, it was not working (text was not highlighted within the manual code box like the sample provided)

Please see below - column [X] in the example is Procedure Code - they are the same thing.

I then get the following error->

[atcodedog05]

Hi @tsilverman_ 

The way your workflow is right it says that it should satisfy filter 1, filter 2,... all filters

If you want to check the Procedure Code in list 1 and  Procedure Code in list 2 below is not the correct code that's why you are getting 0 rows as output