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

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

SusanWinchell-Sweeney2 — Tue, 13 Aug 2019 18:20:09 GMT

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

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

rachelg_esri — Tue, 13 Aug 2019 20:33:30 GMT

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

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

SusanWinchell-Sweeney2 — Tue, 13 Aug 2019 21:07:46 GMT

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

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

rachelg_esri — Tue, 13 Aug 2019 21:37:56 GMT

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