Bug
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.
| Bug-ID-Nummer | BUG-000108625 |
|---|---|
| Eingereicht | October 9, 2017 |
| Zuletzt geändert | June 5, 2024 |
| Gilt für | ArcGIS for Desktop |
| Gefunden in Version | 10.3.1 |
| Betriebssystem | N/A |
| Betriebssystemversion | N/A |
| Status | Will Not Be Addressed |
Zusätzliche Informationen
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.Workaround
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.
Schritte zur Reproduzierung
Bug-ID: BUG-000108625
Software:
- ArcGIS for Desktop
Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert
Weitere Informationen zu diesem Thema erkunden
Nach zugehörigen Informationen suchen
Nach Schulungen zu diesem Thema suchen
Ideen erkunden und Feedback geben
Unterstützung durch ArcGIS-Experten anfordern
Esri Support App herunterladen