In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more 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
7 - Meteor

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