Dynamic Select - Choosing Even Numbers

Question

Hi,

I have summarised some data with a description ID column (group by) and counted (count) the occurrences of these IDs.

I want to separate the counts with an odd/even number, if anyone has any idea how I can do this, that would be great!

For IDs with a count of 3, I would like a new column to say 'unique' for one of them and 'duplicate' for the other two IDs

Thanks!

Emil_Kos · Accepted Answer

Hi @furlonla,

Please check this post for the answer:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Expressions-Filter-Tool-Odd-and-Even-Filtering/m-p/82299/highlight/true#M28941

It should help you.

phottovy · Accepted Answer

I usually use the Mod formula to fine evens and odds. You can use this formula:

Mod([NumberColumn], 2)

If the result of this formula is zero, then it is even.