idea GP tool to select unique rows, break ties using rank fields in ArcGIS Pro Ideas https://community.esri.com/t5/arcgis-pro-ideas/gp-tool-to-select-unique-rows-break-ties-using/idi-p/1527344 <P><EM>ArcGIS Pro 2.9.5; File Geodatabase</EM></P><P>I have a standalone table that has rows with duplicate ASSET_ID values.</P><P>I want to select a single row per set of duplicates. I want to choose what row to select by using multiple rank fields: RANK_PRIMARY, RANK_SECONDARY, etc.&nbsp; I would choose to prioritize the values in the rank fields by sorting ascending or descending order.</P><P>Could a geoprocessing tool be added that can&nbsp;select unique rows and break ties using rank fields?</P> Tue, 27 Aug 2024 12:46:37 GMT Bud 2024-08-27T12:46:37Z GP tool to select unique rows, break ties using rank fields https://community.esri.com/t5/arcgis-pro-ideas/gp-tool-to-select-unique-rows-break-ties-using/idi-p/1527344 <P><EM>ArcGIS Pro 2.9.5; File Geodatabase</EM></P><P>I have a standalone table that has rows with duplicate ASSET_ID values.</P><P>I want to select a single row per set of duplicates. I want to choose what row to select by using multiple rank fields: RANK_PRIMARY, RANK_SECONDARY, etc.&nbsp; I would choose to prioritize the values in the rank fields by sorting ascending or descending order.</P><P>Could a geoprocessing tool be added that can&nbsp;select unique rows and break ties using rank fields?</P> Tue, 27 Aug 2024 12:46:37 GMT https://community.esri.com/t5/arcgis-pro-ideas/gp-tool-to-select-unique-rows-break-ties-using/idi-p/1527344 Bud 2024-08-27T12:46:37Z Re: GP tool to select unique rows, break ties using rank fields https://community.esri.com/t5/arcgis-pro-ideas/gp-tool-to-select-unique-rows-break-ties-using/idc-p/1527351#M31763 <P>have you looked at <A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/find-identical.htm" target="_self">Find Identical</A>?</P> Mon, 26 Aug 2024 18:39:57 GMT https://community.esri.com/t5/arcgis-pro-ideas/gp-tool-to-select-unique-rows-break-ties-using/idc-p/1527351#M31763 SteveLynch 2024-08-26T18:39:57Z Re: GP tool to select unique rows, break ties using rank fields https://community.esri.com/t5/arcgis-pro-ideas/gp-tool-to-select-unique-rows-break-ties-using/idc-p/1527357#M31764 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/1398">@SteveLynch</a>&nbsp;Yes, good point.</P><P>If I understand correctly, Find Identical and Delete Identical don't let me prioritize rows using rank fields.</P> Mon, 26 Aug 2024 18:52:09 GMT https://community.esri.com/t5/arcgis-pro-ideas/gp-tool-to-select-unique-rows-break-ties-using/idc-p/1527357#M31764 Bud 2024-08-26T18:52:09Z