in the Feature class to feature class tool I'm using the following SQL Expression:
value = (SELECT MAX(value) FROM SN66150)
How to I adapt the SQL expression to look for the maximum wind measurement value (the field is called "value") for each feature class that the Iterator is sending its way? Is there an expression for "current input" or similar?
(The SQL expression works for the first weather station, SN66150.)