General Layout
- The Mapping field shows
the mapping information that is currently being edited.
- The Value of target field field
shows the current field name.
- Use the Main Expression field
to enter the case expression that you want to use, if required. This corresponds
to Simple Case and Searched Case statements in CASE statement.
Input areas
The Condition column
contains the different case conditions, and the Target column
shows the target. The Condition panel
lists the case conditions and the Target
Value panel 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 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
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 list,
a list of Source or Target fields is displayed. These can be dragged to their
required position in one of the two input boxes above.
Functions drop-down list
The right-hand drop-down list
shows String Functions by
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 function type that is selected. 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.)