We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Custom Filter

Mzaheer24
7 - Meteor

Hello,

 

How can we filter account  which has more than 1 count. Below is the example.

 

AccountCount
I017704023
I017704023
I017704023
002113192
002113192
220511
67852701
A696981
10 REPLIES 10
nikolinamilincevic
6 - Meteoroid

If you want only those whose count is > 1, that you can do by filtering, as already mentioned.

If you want to avoid repeating of the same accounts, you can add Summerize tool, where you select variable Account and operation GroupBy. That will give you the list of unique accounts with count > 1.

Labels
Top Solution Authors