Configuring a case mapping

Configure case mappings using the Compose Case Mapping Expression editor. They are available only to message-targeted mapping nodes.

  1. Select a source field and a target field.
  2. Select Mapping > Create Case Mapping. The editor shows a table of condition and value pairs.
  3. Select a row to edit. You can add, remove, or move entries in the table as required.
  4. Click OK when you are done.

You can repeat this procedure for each of the targets to which you want to add case mapping.

With case mapping, the Compose Case Mapping Expression editor provides extra built-in facilities where you can:
  • Provide an optional main expression.
  • Insert, append, or delete condition expression pairs.
  • Change the order of condition expression pairs.
There are two forms of case expression and the Compose Mapping Expression Editor uses the value in the Match condition with field to decide which format is relevant. If the value of this field is TRUE (the default), the following format is generated:
CASE
WHEN a=b THEN ...
WHEN c=d THEN ...
WHEN x=y THEN ...
...
END CASE
In this case, the condition window should contain an expression of the format a=b.
If the value of the Match condition with is not TRUE, the following format is generated:
CASE some expression
WHEN a THEN ...
WHEN b THEN ...
END CASE
In this case, 'some expression' is coded in Match condition with and the condition window should contain an expression of the format a.

To add a WHEN clause, right-click the white matrix below Condition or Target and select either Insert Condition or Append Condition.

For both formats of the CASE expression, you can have a catch-all, the ELSE clause:
CASE some expression
WHEN a THEN ...
WHEN b THEN ...
,,,
ELSE z
END CASE
Use the Add Default Statement option in the condition pane to generate the ELSE clause.
Related concepts
Mappings
Mapping types
Message mapping
Related tasks
Modifying the target value using the Compose Mapping Expression editor
Applying a condition
Related reference
Mappings