I need sequential numbers(1,2,3...) for the selected features in the particular feild in attribute table, how to do it?
Hey @YuvarajuDhananjay
You may have luck using this here:https://support.esri.com/en-us/knowledge-base/how-to-sort-and-create-a-sequentially-ordered-id-field-000018847
Cody
What kind of geodatabase?
If it's a mobile or enterprise geodatabase, it could be done in a SQL database view. And then you could join from the FC to the view and use the field calculator to populate the ID field in the FC.
Mobile geodatabase (SQLite):
select c.*, row_number() over (order by population_2021 desc) as sorted_id from cities c
(File geodatabases don't have a row_number() function.)
If it's a file geodatabase (or any kind of geodatabase), you could use the Sort geoprocessing tool in conjunction with a join.
Like this:
In hindsight, I could have joined on Objectid=OrigFID, instead of using my temp_unique_id field.
ArcGIS Pro 3.2.1
Check out this page
https://support.esri.com/en-us/knowledge-base/how-to-sort-and-create-a-sequentially-ordered-id-field-000018847
Check out this arcticle by ESRI Support, It's for ArcMap but it still works in pro! You can modify the python code to fit your needs .https://support.esri.com/en-us/knowledge-base/how-to-create-sequential-numbers-in-a-field-in-arcmap-u-000011137If you want something more simple, calculate your field equal to the ObjectID
this sequential number() is working based on OBJECTID, but I need the numbers without using OBJECTID in just sequential manner how my order is on the attribute table?
You can create sequentially numbered attribute values in Excel and then copy/paste the whole column of values to the attribute table in Arc Pro.
サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
