Configuring a mapping

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

  1. From the Message Flow Mapping editor Overview, select the Target Value that you want to edit. A small box appears at the end of the row.
  2. Click the box at the end of the row to open the Compose Mapping Expression editor.

    Alternatively, from the Outline view, select the value that you want to edit and right-click. Select Edit Mapping from the pop-up menu to open the Compose Mapping Expression editor.

Once the mapping is defined, there are many ways in which you can configure it further:
  • Modify the target value using the Compose Mapping Expression editor.
  • Apply built in functions.
  • Apply user-defined functions.
  • Insert operators.
  • Include additional fields.
Different nodes allow you to configure different parameters:
  • DataUpdate nodes allow you to configure expressions and the WHERE clause.
  • DataInsert nodes can only have expressions.
  • DataDelete nodes can only have WHERE clauses.

For these nodes, the existing method of updating multiple columns in a row is still supported. However, you can map these nodes, as well as the Warehouse node, as a one-to-one mapping. This enables you to merge multiple mappings into a single row in a table, or split a mapping into multiple one-to-one mappings (one for each row).

Related concepts
Mappings
Mapping types
Message mapping
Related tasks
Modifying the target value using the Compose Mapping Expression editor
Applying built-in functions
Applying user-defined functions
Inserting operators
Including additional fields in a mapping
Applying a condition
Configuring a case mapping
Applying ESQL function definitions
Related reference
Mappings