Create Data Loading Workspace (Data Management)

ArcGIS Pro 3.4 | | Help archive

Summary

Creates a data loading workspace that can be used for data loading. The output workspace contains a collection of Microsoft Excel workbooks. These workbooks can be used to configure the source and target schema mapping.

Learn more about data loading workspace concepts

Usage

  • The geometry of the source data will determine the types of data mapping folders that are generated. For example, if you only include point features, only a points folder will be generated.

  • Every time the tool is run, a new workspace will be generated.

  • Create or specify a mapping table to use to match datasets, fields, and attribute domain coded value descriptions from a source and a target schema. The table is used to bidirectionally match substrings so the order is not important. Use the table to create matches or to block them.

  • If a mapping table is provided, the table will be used regardless of the Predictive Field Matching Options parameter value specified.

  • Predictive field matching uses a distance algorithm to match datasets, fields, and coded value descriptions between the source and the target schema.

  • The output from this tool can be used as input to the Load Data Using Workspace and Load Data To Preview tools.

  • This tool supports the following source and target data types:

    • Workspaces
      • File geodatabases
      • Mobile geodatabases
      • Enterprise geodatabases
      • Feature datasets
      • Feature services
      • CAD datasets (.dgn, .dwg, and .dxf files)
    • Tabular datasets
      • Feature classes
      • Tables
      • Feature service layers and tables
      • Shapefiles
      • .csv and delimited text files
      • Excel worksheets
      • CAD layers
      • dBase files

Parameters

LabelExplanationData Type
Source to Target Mapping

Defines how source data will be mapped to the target schema. Both workspaces and individual classes are supported as source or target inputs. When workspaces are used, name similarity is used to match objects in the source and target schemas.

Value Table
Output Folder

The output folder where the data loading workspace will be created.

Folder
Predictive Field Matching Options
(Optional)

Specifies whether field names or domain value descriptions will be matched.

  • Field Name SimilarityField names will be matched based on similarity between the source and target fields.
  • Domain Coded Value Description SimilarityAttribute domain value descriptions will be matched based on similarity between the source and target fields. When this option is specified, fields will not be matched by name if the source or target field has a domain.
String
Mapping Table
(Optional)

A table that will be used to perform substring matching for datasets, values, and attribute domain coded value descriptions. Use the table to create matches or block them.

Record Set
Calculate Row Count Statistics
(Optional)

Specifies whether the count and percentage of filled-in values will be calculated for fields in the source schema.

  • Checked—The count and percentage of filled-in values will be calculated.
  • Unchecked—No calculations will be performed on the field values. This is the default.
Boolean
Create Matches by Subtype
(Optional)

Specifies whether separate data mapping workbooks will be created by subtype if they exist.

  • Checked—Separate data mapping workbooks will be created for each match if they exist. The class name will not be used to match candidates if subtypes exist. This is the default.
  • Unchecked—Dataset matching will only be attempted at the class level. If classes contain subtypes, a subtype sheet will be created in the data mapping workbook.

Boolean

Derived Output

LabelExplanationData Type
Data Loading Workspace

The path to the data loading workspace folder.

Workspace

Environments

This tool does not use any geoprocessing environments.

Licensing information

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

Related topics