Custom Filter match multiple criteria (And relationship)

[luweitroy]

Hello, please help me on the issue I have on custom filter.

Here is the example:

Flter:

1

2

3

4

Data:

Person  Item

J             1

T             1

M            1

N            3

S            2

J             2

M            3

T             2

N             2

B             1

I want to select filter 1&2 to show me the person has both 1&2 item not the person has 1&2 or 1 or2

So in my example, the result should be 

J  1

J   2

T   1

T   2

\Please help me figure out the solution through Alteryx.

Thanks!

[Kenda]

Hey @luweitroy!

After making sure that your Item field is a string, I would use a Summarize tool to group by the Person and concatenate the Item. From there, use a contains function in your Filter tool to keep only the records that have 1 & 2 in the Item field. Use a Text to Columns tool to separate out the rows again and you're done!

[luweitroy]

Well Done! Thanks