Add

Add additional field. Disabled if schema is locked. Unlock the schema and then add the field.

The new field is added and it displays the default type and the default size. By default, the description for new field is empty.

To insert a field in the middle of a field list, select the row before which you want to add the field and click . A new field will be added before the selected row. If no row is selected, then the new field is added to the end of the field list. If all fields are selected and you insert a new field, the new field will be inserted at the end of the field list.

The same behavior occurs when you right-click and select Add Field or when you use the <Insert> key.

Delete

Delete field. Disabled if schema is locked. Unlock the schema and then delete the field. A warning message appears. Click Yes. The selected field is deleted.

Select multiple fields using Ctrl.

You can delete all fields by selecting the field name column and pressing Delete. A warning message is displayed. Click Yes. The fields are deleted.

You can also delete a field by right-clicking and selecting Delete Field.

If the target output mode is Append or Update, you cannot delete the field.

Move Up

Move record up. Disabled if schema is locked.

Move Down

Move record down. Disabled if schema is locked.

Lock Schema

Schema is locked. Click to unlock.

Unlock Schema

Schema is not locked. Click to lock.

Column Picker

Show or hide columns based on your requirement. The selection will be retained for all the maps (new and existing). You can also set the default columns in Options > Preferences window. For more information, see Setting Schema Preferences.

Show Search Bar

Displays the search bar that you can use to search for Source Field, Target Field, Global Variable, or Text String in a map.

Simple View

Displays the source schema and target schema in two panels.

Advanced View

Displays everything that can be configured to control your source to target transformation in four component windows.

Match by

Maps the target fields with source field using Match By Name, Match By Position, or Auto Map options from the drop-down menu.

Show Results/ Hide Results

Toggle icon to show or hide the transformation results. This is the default status if the icon is based on Map Preferences setting.

If Show Results is clicked, the Test Control icons are displayed, the source section displays the Contents column and the target section displays the Results column. If you have multiple targets, then select the required target to view the Transformation Results. To hide the Test Control icons and these two columns, click Hide Results.

For Source, Targets, and Lookups, when you click Show Results, an error message is displayed with Connect for Me button. All the Source, Targets and Lookups are connected successfully with a single click on Connect for Me, if the Source, Targets and Lookups have valid connection information.

The Test Control icons are:

or

Insert/Overwrite

Toggle icon to insert or overwrite the existing target fields. When you drag and drop a field onto any cell to the left of a target expression, it either adds the dropped field or overwrites the existing target field based on the selected icons.

Browse Data

View Source or Target data.