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 Name | rating | Challenge |
1 | 1 | Conversation Starter |
1 | 1 | Reply to a question |
1 | 2 | Reply to discussion |
2 | 1 | Create blog post |
2 | 2 | Docu-mentor |
2 | 2 | Download an Uploaded File |
2 | 1 | Followed |
2 | 2 | Leader of the Pack |
2 | 1 | Liked |
2 | 3 | Posse |
2 | 1 | Post a comment |
2 | 1 | Post a question |
2 | 18 | Read a blog post |
2 | 1 | Tagging |
2 | 1 | Thumbs Up |
2 | 1 | Vote 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
Solved! Go to Solution.
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.
Awesome! Thanks, Jasperich
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.
Best,
Atamert
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?