Generate Predefined Mapping Table (Data Loading)

Summary

Generates a table based on a configured Data Loading Workspace. The output table includes a list of predefined datasets, fields, and attribute domain coded value descriptions.

Usage

  • The Data Reference workbook found in the Data Loading Workspace must be saved before running the tool.

  • This table includes a collection of substrings, delimited by spaces, that are used to match a source to a target schema. The table is used to bidirectionally match substrings; therefore, order is not important.

  • The output table includes the following format for each column and allowable values:

    • type—dataset, field, or value
    • substringsa—user-defined substring
    • substringsb—user-defined substring
    • match_strings—Yes or No

Parameters

LabelExplanationData Type
Data Reference workbook

The Data Reference workbook that will be used to generate a predefined mapping table.

File
Output Table

The output table includes a list of datasets, fields, and attribute domain coded value descriptions based on the source and target mapping from a Data Loading Workspace. Use this table in the Create Data Loading Workspace tool to refine a future iteration of a Data Loading Workspace.

Table

Environments

This tool does not use any geoprocessing environments.

Licensing information

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