Dynamic Select - Choosing Even Numbers

[furlonla]

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 solution]

Hi @furlonla,

Please check this post for the answer:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Expressions-Filter-Tool-Odd-and-Even-F...

It should help you.

[phottovy · Accepted solution]

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.

[furlonla]

Thanks, I have been able to use this to select the even/odd numbers. Is there away to manually put in say first four rows = Duplicate, fifth row = Unique

[furlonla]

Got it using a multi row formula!