Select to view content in your preferred language

ArcMap question - fill series in attribute table - - comparable to Excel?

3651
3
Jump to solution
08-13-2019 11:20 AM
SusanWinchell-Sweeney2
Occasional Contributor

Using the field calculator, is there a formula that will simulate the "fill series" function in Excel for a column in feature class attribute table? I need sequential numbers in a field, starting with record/row #1 through the last record in the attribute table.

When I have need of this before, I simply used the following in the field calculator:

[OID] +1 

The OID or FID typically starts with the number 0, so this works. However, my point layer was heavily edited; the OID is no longer sequential and missing several numbers.

Thank you!

Susan

0 Kudos
1 Solution

Accepted Solutions
SusanWinchell-Sweeney2
Occasional Contributor

Thank you, Rachel! That's exactly what I was looking for...;-)

View solution in original post

3 Replies
rachelg_esri
Esri Contributor

Hello Susan!

Does the following article do what you're looking for? The article does mention that it assumes your records are in order of OID, but I'm not sure how it behaves on missing OIDs as I don't have a dataset to test with. Give this a try and let us know? Thanks!

How To: Create sequential numbers in a field using Python in the Field Calculator 

Best regards,

Rachel

Esri Support Services

Rachel Guttmacher
ArcGIS Online Technology Lead
Esri Support Services
SusanWinchell-Sweeney2
Occasional Contributor

Thank you, Rachel! That's exactly what I was looking for...;-)

rachelg_esri
Esri Contributor

Yay! Glad we could help, Susan! Have a great rest of your day!

Rachel Guttmacher
ArcGIS Online Technology Lead
Esri Support Services
0 Kudos