pcsatdi

increment duplicate records based on a field

Discussion created by pcsatdi on Sep 19, 2012
Latest reply on Sep 19, 2012 by pcsatdi
Hi,

Looking for some simple code to run either in Field Calculator (preferred) or in a python script on a table to create a field and add incremental numbers to that field based on repeating values of another field, for all records.  I've already permanently sorted the table, which I need to do before incrementing the duplicate records.  I can create the field no problem to minimize steps necessary, if someone can provide the basic code for the increment based on a field.  Thanks.

Example table:
FieldA     Dups (created)
3            1
3            2
3            3
1            1
1            2
1            3
1            4
8            1
8            2

Outcomes