I have a point feature layer that contains duplicate records for proximity to similar features. I want to find the rows for each point that has the shortest distance. I tried sorting based on attribute and distance and then used the Delete Identical Tool, hoping that it would leave the first row and remove that rest, but it seems like it just randomly leaves one of the rows and removes the rest. I've attached a screenshot of the table below.
Thanks
Figured it out. Used Summary Statistics
For the statistics field I used the distance with the Minimum Statistics and the Case Field set to the Asset Number unique identifier
Nice! thanks for sharing your solution.
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.