Field Mapping Basics

Field mappings define how data is transformed from source fields to target fields in a Migrate Records step. This article covers the simple mapping types.

Accessing Field Mappings

Open a Migrate Records step (e.g., the Incidents step)
Navigate to the Fields tab
You'll see a table of existing mappings from source fields to target fields

You can edit mappings by selecting rows in the table, or delete existing mappings as needed.

Simple Mapping Types

When creating a new mapping, you'll see several supported types. The simple mappings are:

Constant Value

Maps a fixed value to the target field. The value you provide is used for every record.

String constant: Enter any text value (e.g., migrated)
Integer constant: Enter any numeric value (e.g., 42)

Tip: Take care to match the data type expected by the target field.

Older configurations also expose a deprecated JSON Path simple mapping that extracts a value from a JSON payload via a JSONPath expression. New mappings should use a Formula Mapping with the json_path function instead.

Source Field

Maps a field from the source record directly to the target field. Select a source field from the dropdown, ensuring the data types are compatible.

Procedure Variable

Maps the current value of a procedure variable to the target field. Select a variable from the list — for example, choosing the hello variable would populate every target record with the variable's current value (e.g., PBv10).

Mapping Variable

Maps the value of a mapping variable to the target field. Mapping variables are special fields that appear alongside regular fields in the mapping table but are not loaded into the target table. They are used as intermediate values that can be referenced by other field mappings.

Key characteristics of mapping variables:

They exist alongside regular field mappings in the table
They are calculated during processing but not written to the target
They allow you to chain mappings together for complex operations
They help avoid repeating the same logic in multiple field mappings

You can create your own mapping variables with the Add Mapping Variable button in the toolbar above the mapping table (on narrow panes this action is in the vertical ellipsis menu). Read the tooltip for further information about how mapping variables work.

Configuring Field Mappings — walkthrough of the Fields tab on a Migrate Records step
Formula Mappings — using expressions to compute field values
Advanced Mappings — Match, Lookup, and ID mapping types
Formula Language — full formula syntax and functions reference