I am trying to build a model that will first select a group of points based on an ID field and then select the lowest value in a distance field so I will get the shortest distance for each group. Is there a way to build a query for that? Thanks! Rebecca
I am trying to build a model that will first select a group of points based on an ID field and then select the lowest value in a distance field so I will get the shortest distance for each group. Is there a way to build a query for that? Thanks! Rebecca
No, not within a single table/feature class. There is a way to do it if there are two tables/feature classes. See the discussion on Subqueries here. I normally use the SummaryStatistics tool in the Analysis group to get a Min value and join it to the ID to select the lowest record or make other adjustments relative to the minimum value.
Please mark the thread answered for the benefit of others looking for solutions to similar problems. I assume you used the SummaryStatistics approach given the speed of your respoinse. Thanks.
