Iterate Tables (ModelBuilder)


Iterates over tables in a workspace.

Learn how Iterate Tables works in ModelBuilder


  • 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 first table identified by the tool is used as a template for the output Table parameter. The tool reads information from this table, including the fields and the full path to the table. This allows for the selection of fields in the parameters of subsequent tools when initially setting up the model workflow. When the model is first run, the tool will use the information from the first table, and on subsequent runs, each table is individually read and the information is sent to the next tool.

  • The tool has two outputs, Table and Name, which can be used as inline variables (for example, %Name%) in other tools.


LabelExplanationData Type

A workspace containing the tables to iterate.


A combination of * and characters that help to limit the results. The asterisk is the same as specifying 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).

Table Type

Specifies the table type for folder workspaces (shapefiles and coverages).

  • dBASE (shapefiles)The table type will be dBASE tables (shapefiles).
  • INFO (coverages)The table type will be INFO tables (coverages).

Specifies whether subfolders in the main folder will be iterated recursively.

  • Checked—All subfolders in the main folder will be iterated recursively.
  • Unchecked—Subfolders in the main folder will not be iterated recursively. Only the main folder will be used.

Derived Output

LabelExplanationData Type

The full path to the table.


The name of the table.



This tool does not use any geoprocessing environments.

Licensing information

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

Related topics