Error
The Table Select tool produces inaccurate results when using the subquery GROUP BY clause with an input table that has several unique numeric values in the field to be grouped.
| Número de ID del error | BUG-000108625 |
|---|---|
| Enviado | October 9, 2017 |
| Última modificación | June 5, 2024 |
| Relacionado con | ArcGIS for Desktop |
| Versión encontrada | 10.3.1 |
| Sistema operativo | N/A |
| Versión de sistema operativo | N/A |
| Estado | Will Not Be Addressed |
Información adicional
A where clause query with the provided syntax is not expected to return a result for the Table Select tool that contains the max value per GROUP BY, rather all rows whose value of WATER are the maximum in any group.Solución alternativa
Use the Summary Statistics geoprocessing tool or open the table, right-click the GROUP BY field and select Summarize. This creates a table containing one record for each unique value of the selected field (the GROUP BY field), along with statistics for any of the other fields as designated.
Pasos para reproducir
ID del error: BUG-000108625
Software:
- ArcGIS for Desktop
Recibir notificaciones cuando cambie el estado de un error
Descubrir más sobre este tema
Buscar información relacionada
Encontrar formación relacionada con este tema
Explorar ideas y aportar opiniones
Obtener ayuda de expertos en ArcGIS
Descargar la aplicación de soporte de Esri