Compose Case Mapping Expression editor

The Compose Case Mapping Expression editor is used to add value to the mappings that are already defined in the Mapping view. Use the editor to define more clearly how the values should be assigned and manipulated. You can also add other fields and apply different built-in and user-defined functions where required.

The editor is available in the Broker Application Development perspective; it is launched when you double-click a Target value field in the Overview view.

Compose Case Mapping Expression editor views

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.)

Compose Case Mapping Expression editor toolbar

The Compose Case Mapping Expression editor does not provide any additional icons and actions on the toolbar.

Related concepts
Mappings
Related tasks
Developing mappings