I am trying to run a model to select the maximum (wind measurement) value from each weather station (called SNXXXXX), which has their own feature class in my input gdb: my model

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.)

  • It should do this automatically. Are you really trying to create a new feature class for each input with the maximum selected in that class? – danak May 2 at 21:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.