Configuring a mapping

Use the Compose Mapping Expression editor to configure mappings for:
  • nodes that target messages
  • nodes that target databases (for example the DataUpdate, DataDelete, DataInsert 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 to open the Compose Mapping Expression editor.

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

After the mapping has been 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.
Use the appropriate node to configure different parameters:
  • Use DataUpdate nodes 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