Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
There's still time to register for the Q3 ACE Panel - Spatial Edition presentation tomorrow! | Need more information about the event? Check out the post here

Filter Based on User Count

7 - Meteor

Hi All!


I'm trying to filter records based on those with more than 4 user entries. So, in the following table, I would keep user name = 2, because they have more than 4 entries, where I would want to remove user name 1 because they only have 3 entries

User NameratingChallenge
11Conversation Starter
11Reply to a question
12Reply to discussion
21Create blog post
22Download an Uploaded File
22Leader of the Pack
21Post a comment
21Post a question
218Read a blog post
21Thumbs Up
21Vote on an idea

I have tried the summarize tool, and then filter, but I can't quite figure it out. I'm also attaching the csv if anyone wants to look

12 - Quasar

Hi @m1ngle74


I think you method is pretty close to what you want to achieve. All you need to do it to join the result back to the original dataset. 



7 - Meteor

Awesome! Thanks, Jasperich

8 - Asteroid

Dear all,


how can I filter out the rows based on a specific number of counts of multiple columns at once?


In the use case above we use only one column to base our condition on and I need to do something similar for multiple columns at the same time.




Alteryx Certified Partner
Alteryx Certified Partner

Basically, you can use the method @jasperlch used for one column, but slightly extended. You will need one Summarize tool for each column you want to use as a criterion, join data and all totals use Join Multiple and connect a filter to the output of the join tool.

Does that solve your problem?