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.
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 Once you apply the below filter tool you will get the odd and even number seperate
hi @binu_acs , 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.
@yanatodorova26 One way of doing this
Hi, @yanatodorova26
Kindly consider the below - I hope you find it helpful. Cheers!
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.
