If Field Value Is (ModelBuilder)

Summary

Evaluates if the values in an attribute field match a specified value, expression, or second field.

Learn how If Field Value Is works in ModelBuilder

Usage

• This tool is only available from ModelBuilder for use in models. The tool is not available from the Geoprocessing pane or from Python.

• The tool has two Boolean outputs, True and False. Based on the condition being evaluated, one of the two Boolean outputs is true and the other is false after the tool runs. These Boolean outputs must be set as a precondition to the downstream tools for those to run if either of the preconditions is true.

Parameters

Dialog

Label	Explanation	Data Type
Input Data Element	Input element to be evaluated.	Data Element; Layer; Table View; Raster Layer; Mosaic Layer; Graph; Utility Network
Expression	An SQL expression used to select a subset of records. For more information on SQL syntax see SQL reference for query expressions used in ArcGIS.	SQL Expression
Invert Where Clause (Optional)	Specifies whether the expression will be used as is, or the opposite of the expression will be used. Unchecked—The query will be used as is. This is the default. Checked—The opposite of the query will be used. If the Selection Type parameter is used, the reversal of the selection occurs before it is combined with existing selections.	Boolean
Selection Condition	The selection condition to use for the field values of the records matching the SQL expression. Exists—Checks if any records match the SQL expression. This is the default. No Selection—Checks if none of the records match the SQL expression. All Selected—Checks if all of the records match the SQL expression. Is Equal to—Checks if the number of records that match the SQL expression is equal to the Count value. Is Between—Checks if the number of records that match the SQL expression is between the Minimum Count value and Maximum Count value. Is Less Than—Checks if the number of records that match the SQL expression is less than the Count value. Is Greater Than—Checks if the number of records that match the SQL expression is greater than the Count value. Is Not Equal to—Checks if the number of records that match the SQL expression is not equal to the Count value.	String
Count (Optional)	The integer count value.	Long
Minimum Count (Optional)	The minimum integer count value.	Long
Maximum Count (Optional)	The maximum integer count value.	Long

Derived Output

Label	Explanation	Data Type
True	If the specified criteria evaluates to True, this parameter will be set to True.	Boolean
False	If the specified criteria evaluates to False, this parameter will be set to True.	Boolean

Environments

This tool does not use any geoprocessing environments.

Licensing information

• Basic: Yes
• Standard: Yes
• Advanced: Yes