Iterate Tables (ModelBuilder)—ArcGIS Pro

Summary

Iterates over tables in a workspace.

This tool is only available from ModelBuilder 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, that can be used as inline variables (for example, %Name%) in other tools.
The tool works with many tabular file formats, including Excel files and comma-delimited text files (.csv and .txt).

Label	Explanation	Data Type
Workspace	A 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 specifying ALL. If no wildcard is specified, all inputs will be returned. You can use this parameter 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)	Specifies the table type for folder workspaces (coverages). dBASE—The table type will be dBASE tables. INFO (coverages)—The table type will be INFO tables (coverages). File geodatabase—The table type will be file geodatabase tables. Excel—The table type will be Microsoft Excel tables. Delimited text file—The table type will be delimited text files. This includes .csv files. SQLite—The table type will be SQLite tables. Enterprise geodatabase—The table type will be enterprise geodatabase tables. OLE DB—The table type will be OLE DB connection tables.	String
Recursive (Optional)	Specifies whether subfolders in the main folder will be iterated recursively. Checked—All subfolders in the main folder will be iterated recursively. Keep this parameter checked to enable iterating through multiple file geodatabase tables or SQLite tables in the input workspace. Unchecked—Subfolders in the main folder will not be iterated recursively. Only the main folder will be used.	Boolean

This tool does not use any geoprocessing environments.