ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Iterate Tables

  • Summary
  • Usage
  • Syntax
  • Environments
  • Licensing Information

Summary

Iterates over tables in a workspace.

Learn how Iterate Tables works in ModelBuilder

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

IterateTables_mb (in_workspace, {wildcard}, {table_type}, {recursive})
ParameterExplanationData 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.

  • DBASE —dBASE table (shapefiles)
  • INFO —INFO table (coverages)
String
recursive
(Optional)

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

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

Environments

This tool does not use any geoprocessing environments

Licensing Information

  • ArcGIS for Desktop Basic: Yes
  • ArcGIS for Desktop Standard: Yes
  • ArcGIS for Desktop Advanced: Yes

Related Topics

  • An overview of the Iterator toolset
  • A quick tour of using iterators
Feedback on this topic?

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal