If Row Count Is (ModelBuilder)

Summary

Evaluates the row count of the input data and checks whether it matches a specified value.

Learn how If Row Count Is works in ModelBuilder

Usage

  • This tool is intended for use in ModelBuilder, 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 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.

Syntax

arcpy.mb.RowCountIfThenElse(in_layer_or_view, {count_condition}, {count}, {count_min}, {count_max})
ParameterExplanationData Type
in_layer_or_view

The input layer or table view to evaluate.

Table View; Raster Layer; Mosaic Layer
count_condition
(Optional)

Specifies the condition to be used to test the field values of the records matching the SQL expression.

  • IS_EQUAL_TOChecks if the row count is equal to the Count value.
  • IS_BETWEENChecks if the row count is between the Minimum Count value and Maximum Count value.
  • IS_LESS_THANChecks if the row count is less than the Count value.
  • IS_GREATER_THANChecks if the row count is greater than the Count value.
  • IS_NOT_EQUAL_TOChecks if the row count is not equal to the Count value.
String
count
(Optional)

The integer count value.

Long
count_min
(Optional)

The minimum integer count value.

Long
count_max
(Optional)

The maximum integer count value.

Long

Derived Output

NameExplanationData 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