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 the ModelBuilder ribbon 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 execute if either of the preconditions is true.

Parameters

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

  • ExistsChecks if any records match the SQL expression. This is the default.
  • No SelectionChecks if none of the records match the SQL expression.
  • All SelectedChecks if all of the records match the SQL expression.
  • Is Equal toChecks if the number of records that match the SQL expression is equal to the Count value.
  • Is BetweenChecks if the number of records that match the SQL expression is between the Minimum Count value and Maximum Count value.
  • Is Less ThanChecks if the number of records that match the SQL expression is less than the Count value.
  • Is Greater ThanChecks if the number of records that match the SQL expression is greater than the Count value.
  • Is Not Equal toChecks 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

LabelExplanationData 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

Related topics