I have a large feature class table with wind measurements from weather stations. It has the following fields:
- Station ID field (repeated hundreds of times)
- Measurement result
- Date of the measurement
I'd like to select the highest measurement result from each of the stations and preserve both the measurement result and the date fields.
Using Dissolve tool (with the statistic field set to max for the measurement field) means I lose the date field. A later join will not give the exact date for the highest measurement.
I've considered Split features by station ID to iterate selecting the highest value (with the aim of merging them with only the selected max values), but cannot find a SQL expression that returns the max measurement value. I've tried
[MeasurementField] in (SELECT max([MeasurementField]) FROM WindMeasurementTable)
But with no success.
I am using both ArcGIS Desktop 10.3 and Pro.