Derived script is used to pre-process incoming data to create records with custom values. The user is able to add text as well as use the existing columns as variables within the script. A Derived Script can be added at any time by clicking the "Add Derived Script" button.

1. A window will popup allowing the user to enter the derived script. In the example to the right, the value in column 2 will be concatenated to the value of column 1.
2. When the user is satisfied with the script they can select “Ok”.

When a derived script is added it adds a Source row record which can be mapped to a target tree item just like any other source row. The value in the Data field on the source row record shows the derived script as it was entered.

1. The user is able to delete or edit the derived script by right-clicking on a derived script row. If the user selects "Delete Derived Script", it will remove the derived script row. Other source rows cannot be removed in this manner. A target tree item can either be mapped to a source row or to a derived column, but not both.