community
cancel
Showing results for 
Search instead for 
Did you mean: 

community Lounge

Get to know your fellow analytics buffs and discuss a wide range of topics!

Custom Filter match multiple criteria (And relationship)

Meteoroid

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!

Pulsar
Pulsar

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

Meteoroid

Well Done! Thanks