Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Dynamic Select - Choosing Even Numbers

furlonla
8 - Asteroid

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!

4 REPLIES 4
Emil_Kos
17 - Castor
17 - Castor
phottovy
13 - Pulsar
13 - Pulsar

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
8 - Asteroid

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
8 - Asteroid

Got it using a multi row formula!

Labels