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 intended for use in ModelBuilder and not in Python scripting.

• 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 false after the tool runs. These boolean outputs have to be set as a precondition to the downstream tools for those to execute if either of the preconditions is true.

Syntax

FieldValueIsIfThenElse(in_data, where_clause, {invert_where_clause}, selection_condition, {count}, {count_min}, {count_max})

Parameter	Explanation	Data Type
in_data	Input element to be evaluated.	Data Element; Layer; Table View; Raster Layer; Mosaic Layer; Graph; Utility Network
where_clause	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 result of the expression should be inverted. NON_INVERT —The result of the query will be used as is. This is the default. INVERT —The result of the query will be inverted. If the selection_type parameter is used, the inversion occurs before the selection 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)	An integer count value.	Long
count_min (Optional)	A minimum integer count value.	Long
count_max (Optional)	A maximum integer count value.	Long

Derived Output

Name	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