Assign odd number as a record ID

[yanatodorova26]

Hi,

Is someone aware how can I assign a RecordID to be only odd numbers and vice versa - another recordID tool to assign only even numbers?

The idea would be to assign in a new column only odd or only even numbers as ID.

[binuacs]

@yanatodorova26 Once you apply the below filter tool you will get the odd and even number seperate 

[yanatodorova26]

hi @binuacs , i want to add a new column that is having the idea of the RecordID, but instead of inserting consecutive numbers, to assign only odd values. i.e to have the ids 1,3,5,7, etc.

[binuacs]

@yanatodorova26 One way of doing this

[RobertOdera]

Hi, @yanatodorova26 

Kindly consider the below - I hope you find it helpful. Cheers!

[danilang · Accepted solution]

Hi @yanatodorova26 

A very simple way to do this is to add Record ID tool and then use a formula tool to modify the [RecordID] column.  [RecordID]*2-1 gives you odd numbers and [RecordID]*2 gives you the even ones

Dan

[yanatodorova26]

Hi All, thank you for the variety of possible solutions! They all are very helpful and interesting. I was able to solve it the following way:

1. Add a Record ID

2. Add a formula tool to modify the RecordID with the following expression: 2*[RecordID]+1 which will modify the ids to only odd ones.