Iterate Field Values (ModelBuilder)


Iterates over each value in a field.

Learn how Iterate Field Values works in ModelBuilder


  • This tool is intended for use in ModelBuilder, not in Python scripting.

  • The output of the tool is a variable named Value and contains the value of the field. This variable can be used in inline variable substitution (%Value%).

  • The Data Type parameter specifies the data type of the output variable. The default data type is string, but depending on how the output will be used in the model, other data types can be specified. For example, if your field contains the path to a feature class, you can set the Data Type parameter to Feature Class and use the output variable as input to a tool that accepts a feature class.

  • If an iterator is added to a model, all tools in the model iterate for each value in the iterator. If you do not want to run each tool in the model for each iterated value, create a submodel, model within a model, or nested model that contains only the iterator and add it as a model tool to the main model.


arcpy.mb.IterateFieldValues(in_table, field, {data_type}, {unique_values}, {skip_nulls}, {null_value})
ParameterExplanationData Type

The input table to be iterated.

Table View; Raster Layer

The input field for iteration.


Specifies the data type of the output value. The default data type is string, but depending on how the output will be used in the model, other data types can be specified. For example, if your field contains the path to a feature class, you can set this parameter to Feature Class and use the output variable as input to a tool that accepts a feature class.

  • Address LocatorAddress Locator
  • Address Locator StyleAddress Locator Style
  • Analysis Cell SizeAnalysis Cell Size
  • Annotation LayerAnnotation Layer
  • Any ValueAny Value
  • ArcMap DocumentArcMap Document
  • Areal UnitAreal Unit
  • BIM File WorkspaceBIM File Workspace
  • BooleanBoolean
  • Building Discipline LayerBuilding Discipline Layer
  • Building Discipline Scene LayerBuilding Discipline Scene Layer
  • Building LayerBuilding Layer
  • Building Scene LayerBuilding Scene Layer
  • CAD Drawing DatasetCAD Drawing Dataset
  • Calculator ExpressionCalculator Expression
  • Catalog RootCatalog Root
  • Cell SizeCell Size
  • Cell Size XYCell Size XY
  • Composite LayerComposite Layer
  • CompressionCompression
  • Coordinate SystemCoordinate System
  • Coordinate Systems FolderCoordinate Systems Folder
  • CoverageCoverage
  • Coverage Feature ClassCoverage Feature Class
  • Data ElementData Element
  • Data FileData File
  • Database ConnectionsDatabase Connections
  • DatasetDataset
  • DateDate
  • dBASE TabledBASE Table
  • DecimateDecimate
  • Diagram LayerDiagram Layer
  • Dimension LayerDimension Layer
  • Disk ConnectionDisk Connection
  • DoubleDouble
  • Elevation Surface LayerElevation Surface Layer
  • Encrypted StringEncrypted String
  • EnvelopeEnvelope
  • Evaluation ScaleEvaluation Scale
  • ExtentExtent
  • Extract ValuesExtract Values
  • Feature ClassFeature Class
  • Feature DatasetFeature Dataset
  • Feature LayerFeature Layer
  • Feature SetFeature Set
  • FieldField
  • Field InfoField Info
  • Field MappingsField Mappings
  • FileFile
  • FolderFolder
  • Formulated RasterFormulated Raster
  • Fuzzy functionFuzzy function
  • GeoDataServerGeoDataServer
  • GeodatasetGeodataset
  • Geometric NetworkGeometric Network
  • Geostatistical LayerGeostatistical Layer
  • Geostatistical Search NeighborhoodGeostatistical Search Neighborhood
  • Geostatistical Value TableGeostatistical Value Table
  • GlobeServerGlobeServer
  • GPServerGPServer
  • GraphGraph
  • Graph Data TableGraph Data Table
  • Group LayerGroup Layer
  • Horizontal FactorHorizontal Factor
  • Image ServiceImage Service
  • IndexIndex
  • INFO ExpressionINFO Expression
  • INFO ItemINFO Item
  • INFO TableINFO Table
  • Internet Tiled LayerInternet Tiled Layer
  • KML LayerKML Layer
  • LAS DatasetLAS Dataset
  • LAS Dataset LayerLAS Dataset Layer
  • LayerLayer
  • Layer FileLayer File
  • LayoutLayout
  • LineLine
  • Linear UnitLinear Unit
  • LongLong
  • M DomainM Domain
  • MapMap
  • Map Server LayerMap Server Layer
  • MapServerMapServer
  • Mosaic DatasetMosaic Dataset
  • Mosaic LayerMosaic Layer
  • NeighborhoodNeighborhood
  • Network Analyst Class FieldMapNetwork Analyst Class FieldMap
  • Network Analyst Hierarchy SettingsNetwork Analyst Hierarchy Settings
  • Network Analyst LayerNetwork Analyst Layer
  • Network Data SourceNetwork Data Source
  • Network DatasetNetwork Dataset
  • Network Dataset LayerNetwork Dataset Layer
  • Network Travel ModeNetwork Travel Mode
  • Parcel FabricParcel Fabric
  • Parcel Fabric for ArcMapParcel Fabric for ArcMap
  • Parcel Fabric Layer for ArcMapParcel Fabric Layer for ArcMap
  • Parcel LayerParcel Layer
  • PointPoint
  • PolygonPolygon
  • Projection FileProjection File
  • PyramidPyramid
  • RadiusRadius
  • Random Number GeneratorRandom Number Generator
  • Raster BandRaster Band
  • Raster Calculator ExpressionRaster Calculator Expression
  • Raster CatalogRaster Catalog
  • Raster Catalog LayerRaster Catalog Layer
  • Raster Data LayerRaster Data Layer
  • Raster DatasetRaster Dataset
  • Raster LayerRaster Layer
  • Raster StatisticsRaster Statistics
  • Raster TypeRaster Type
  • Record SetRecord Set
  • Relationship ClassRelationship Class
  • RemapRemap
  • ReportReport
  • Route Measure Event PropertiesRoute Measure Event Properties
  • Scene LayerScene Layer
  • SemivariogramSemivariogram
  • ServerConnectionServerConnection
  • ShapefileShapefile
  • Spatial ReferenceSpatial Reference
  • SQL ExpressionSQL Expression
  • StringString
  • String HiddenString Hidden
  • TableTable
  • Table ViewTable View
  • Terrain LayerTerrain Layer
  • Text FileText File
  • Tile SizeTile Size
  • Time configurationTime configuration
  • Time UnitTime Unit
  • TIN LayerTIN Layer
  • ToolTool
  • ToolboxToolbox
  • Topo FeaturesTopo Features
  • TopologyTopology
  • Topology LayerTopology Layer
  • Trace NetworkTrace Network
  • Trace Network LayerTrace Network Layer
  • Transformation functionTransformation function
  • Utility NetworkUtility Network
  • Utility Network LayerUtility Network Layer
  • VariantVariant
  • Vector Tile LayerVector Tile Layer
  • Vertical FactorVertical Factor
  • Voxel LayerVoxel Layer
  • VPF CoverageVPF Coverage
  • VPF TableVPF Table
  • WCS CoverageWCS Coverage
  • Weighted Overlay TableWeighted Overlay Table
  • Weighted SumWeighted Sum
  • WMS MapWMS Map
  • WorkspaceWorkspace
  • XY DomainXY Domain
  • Z DomainZ Domain

Specifies whether iteration values will be based on unique values.

  • Checked—The iteration values will be based on the unique value of the specified field.
  • Unchecked—The iteration will run for each record in the input table.

Specifies whether null values in the field will be skipped.

  • Checked—Null values in the field will be skipped during selection.
  • Unchecked—Null values in the field will not be skipped during selection.

The null value to skip, such as -9999, Null, or -1. The default values are "" for strings and "0" for numbers.


Derived Output

NameExplanationData Type

The field value returned by each iteration.

Any Value


This tool does not use any geoprocessing environments.

Licensing information

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