General Layout
The Mapping field
shows the mapping information that is currently being edited. The Value of target field field shows
all the output columns that are selected when the mapping was created.
Input area
The large white window contains the target
value, or values, and can be manipulated using the editor tools described
below. Here you can enter the WHERE clause of a Data Delete statement; for
example, when a row should be deleted.
Operator buttons
The buttons on the right side of the
screen contain the operators that can be inserted to the input area described
above. Position the cursor where you want the operator to be inserted and
click the appropriate button. The chosen operator is inserted at the cursor
position.
Fields drop-down list
There are two drop-down lists
available towards the bottom of the panel. The drop-down on the left shows Source fields by default. By clicking
on the drop-down arrow, you can also select Output
fields. When you click the button next to the drop-down button,
a list of Source or Target fields is displayed. These can be dragged to their
required position in the box above.
Functions drop-down list
The right-hand drop-down list
shows String Functionsby
default. By clicking on the drop-down arrow, you can also select other function
types. Clicking on the arrow to the right shows all the functions that are
available for the selected function type. To use one of these functions, highlight
the field or fields to which you want to apply the function, select the function
that you want to use, then drag and drop it onto the highlighted fields. (Alternatively,
drag and drop the function where you want it and complete the necessary fields
later.)