I want to edit an existing feature table that has 100,000 rows. Now, I need to add a field with just numbers from 1-100,000 without adding it one after the other. Please, could you help out on how I can do that faster.
Thanks.
Thanks.
- My favorite method is to copy the table into Excel (copy/paste from the attribute table and save as a .xls file) then it's fast to add new numbers to a whole column. Then use the Join Field tool to add the new column into your attribute table using the OID/FID as the key. It's fast, easy, and doesn't involve coding.
- take a look at www.ian-ko.com He has some free tools in his easy calc download. Specifically:
rec_Number.cal
Which
Populates the field with consecutive numbers. Starting number and a step size can be adjusted
I've used this in the past and it's great; all his stuff is....
http://support.esri.com/en/knowledgebase/techarticles/detail/31374