Summary
Iterates over tables in a workspace.
Usage
This tool is intended for use in ModelBuilder and not in Python scripting.
Tables in a folder can be restricted to iterate on table types such as dBASE and INFO.
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 in-line variable (e.g. %Name%) in other tools.
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 sub-model/model within a model/nested model that contains only the iterator and add it as a model tool into the main model.
Syntax
arcpy.mb.IterateTables(in_workspace, {wildcard}, {table_type}, {recursive})| Parameter | Explanation | Data Type |
in_workspace | Workspace containing the tables to iterate. | Workspace |
wildcard (Optional) | 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 (e.g., A* or Ari* or Land*,and so on). | String |
table_type (Optional) | For folder workspaces (shapefiles and coverages), choose the table type.
| String |
recursive (Optional) | Determines if subfolders in the main folder will be iterated through recursively.
| Boolean |
Derived Output
| Name | Explanation | Data Type |
| table | ||
| name |
Environments
This tool does not use any geoprocessing environments.
Licensing information
- Basic: Yes
- Standard: Yes
- Advanced: Yes