Select to view content in your preferred language

Calculate Unique ID's based on table sort

3658
10
Jump to solution
05-19-2020 08:04 AM
JeremyJones1
Emerging Contributor

Hi All.. So here is what I'm trying to do.  I know how to calculate Unique ID's.  What I'm trying to do is calculate them based the the sort of the table.  My data was randomly selected and on this field the table has been sorted.  I want to then calculate the Unique ID's based on this sort.  So my first record will get a 1 and so on.  What currently happens is the unique ID is created based on the object ID or FID not sure which causing my sort on my field to be invalid.  Is there a way to force the Unique ID to calculate based on the table sort?  Thanks

-Jeremy 

0 Kudos
10 Replies
DanPatterson
MVP Esteemed Contributor

game on 


... sort of retired...