Using Mapping editor

To start configuring Mapping for the transformation, click MAPPING.

On the Mapping page of the Flow Editor, you can map the source to the destination, and, consequently, the source fields to the destination fields.

Control elements

• FROM: the source object. If the source is linked to a live Connection, the object can be selected from a drop-down.
• TO: the destination object. If the destination is linked to a live Connection, the object can be selected from a drop-down list.
• Source query: an SQL query that extracts data from the source object. Read how to execute SQL queries against files and API endpoints.
• Destination query: this field is only visible if the destination is an SQL database.
• Create Mapping: click this button to automatically create a Mapping between the source and destination fields.
• Remove Mapping: click this button to remove the existing Mapping between source and destination fields.
• +: click this button to add a new pair of fields to the Mapping.
• Clear Cache: click this button to clear the metadata cache for the source and destination Connections. Use it when you cannot find the object you are looking for. It might be the result of a change in the metadata, for example, when a new table is added to the database or a new field is added to the table. Read how to clear the cache in the metadata selector.
• Back: go back to the previous screen.

The Fields

• The Drag-and-drop icon: grab it and move UP/DOWN to change the order of the fields.

New fields (fields which don't exist in the source) will be added to the end, regardless of the previous order.

• SOURCE: the source field. You can select it from a drop-down if the source is linked to a live Connection. Read how to use templates to populate source fields.
• DESTINATION: the destination field. You can select it from a drop-down if the source is linked to a live Connection. Read how to use templates to populate destination fields.
• Exclude: click the radio button if you want to exclude this field. Excluded fields will not appear in the destination.
• Add Field: click this radio button if you want to add a field which does not exist in the source.
• Edit field value function: click this button and enter a field value function using JavaScript. You can refer to other fields using their {"field name"}. For example:

• {"Last Name"} + ',' + {"First Name"};

• Make this field a child of the one above: click this button to mark a selected source field as a child of the source field above it. This allows you to define a nested data object. The concept of nested data objects is explained in the section working with nested data objects.
• Move child field up one level: click this button to remove "nestedness" from the selected source field.
• Data type: by default, a destination field gets its data type from the source field. To change the destination data type, click Data type, select a Data typefrom the drop-down or, if needed, enter a Data specific type (for example, varchar(255)). You can also specify if the field is nullable.