Iterate Tables (ModelBuilder)

Summary

Iterates over tables in a workspace.

Learn how Iterate Tables works in ModelBuilder

Usage

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

  • The first input table is used as a template for the output. This allows for selection of fields in subsequent tools.

  • The tool has two outputs: Table and Name, which could be used as inline variable (e.g. %Name%) in other tools.

Syntax

arcpy.mb.IterateTables(in_workspace, {wildcard}, {table_type}, {recursive})
ParameterExplanationData Type
in_workspace

Workspace containing the tables to iterate.

Workspace
wildcard
(Optional)

A combination of * and characters that help to limit the results. The asterisk is the same as saying ALL. If no wildcard is specified, all inputs will be returned. For example, it can be used to restrict Iteration over input names starting with a certain character or word (for example, A* or Ari* or Land* and so on).

String
table_type
(Optional)

For folder workspaces (shapefiles and coverages), choose the table type.

  • DBASEdBASE table (shapefiles)
  • INFOINFO table (coverages)
String
recursive
(Optional)

Determines if subfolders in the main folder will be iterated through recursively.

  • Checked—Will iterate through all subfolders.
  • Unchecked—Will not iterate through all subfolders.
Boolean

Derived Output

NameExplanationData Type
table

The full path to the table.

Table
name

The name of the table.

String

Environments

This tool does not use any geoprocessing environments.

Licensing information

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