First Record

View the first record.

Previous 10 Records

View the previous ten records.

Previous Record

View the previous record.

 

Empty text box

View a specific record.

Next Record

View the next record.

Next 10 Records

View the next 10 records.

Last Record

View the last record.

Reset Globals Now

Reset global variables used in the field expressions.

Reset Globals Every Record

Test each source record as if it were the first record in the source file or table.

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.

You can also add a field by right-clicking and selecting Add Field.

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 the Delete key. 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.

Show Results

Toggle icon to show or hide the transformation results. This default status if this icon is based on the 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. To hide the Test Control icons and these two columns, click Hide Results.