Hello,
How can we filter account which has more than 1 count. Below is the example.
Account | Count |
I01770402 | 3 |
I01770402 | 3 |
I01770402 | 3 |
00211319 | 2 |
00211319 | 2 |
22051 | 1 |
6785270 | 1 |
A69698 | 1 |
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.