General Layout
Beneath the Mapping Details section
at the top of the window, there is a field called
Mapping that
shows the mapping information currently being edited. Directly beneath that
is another field called
Value of target
field, showing the current field name. Beneath that is another
field called
Main Expression where
you can enter the case expression to be used, if required. This corresponds
to
Simple Case and
Searched Case statements in
CASE statement.
Input areas
In the top panel the Condition column
contains the different case conditions, and the Target column
shows the target. The panel entitled Condition lists
the case conditions. The panel titled Target
Value lists the targets.
Operator buttons
The buttons on the right side of the
screen contain the operators that can be inserted into the input area described
above. Position the cursor where you want the operator inserted and click
on the appropriate button. The chosen operator is placed 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 by default
shows Source fields. By
clicking on the drop-down arrow Output
fields can also be selected. When the button immediately to the
right of the drop-down button is clicked, a list of Source or Target fields
is displayed. These can be selected and then dragged to their required position
in one of the two input boxes above.
Functions drop-down list
The right-hand drop-down list
by default shows String Functions.
By clicking on the drop-down arrow, other function types can also be selected.
Clicking on the arrow to the right shows all the functions available for the
function type selected. To use one of these functions you can first highlight
the field or fields you want to apply the function to, select the function
you want to use, and then drag and drop it onto the highlighted fields. Alternatively
you can simply drag and drop the function where you want it and complete the
necessary fields later.