Select by Attribute using variable in Model Builder

DavidDurst

I'm very new at Model Builder and am trying to make a tool that selects features by attribute, with an input variable as part of the SQL query.

I have used the SQL expression MOD(Elevation,10)=0, for instance to only display elevation contour lines every 10 units out of a dataset that has a more dense spacing (say 1 unit). This works great when using the Select by Attribute tool and setting a definition query, but in this case, I need an input parameter in my model instead of a hard-coded 10 units.

Here is an example of what I'm trying to do:

When I draw my line from Supplementary Interval to Select Layer by Attribute, the entire model after Input Feature Class gets greyed out:

How can I specify the second integer parameter of the MOD() function so that I can do my selections? Any help would be appreciated.

Anonymous User

Would something like this work for you? Right click on Select Layer by Attribute  then Create Variable from Parameter then Expression. The user will be prompted to enter a value:

I would also suggest reading up on inline variable substitutions: Inline variable substitution—ArcGIS Pro | Documentation