Adding an expression to a mapping group

Your mapping model can include expressions that filter columns, sort rows, or join tables.
Prerequisites:
  • Creating a mapping model
  • Create mappings between a source and a target, or run the discover function and accept at least one mapping.

The expression builder creates expressions that you use as part of the mapping model. You can then generate the mapping model into SQL statements that include these filters, sort conditions, or join conditions.

To build an expression in the mapping model:

  1. Right-click a mapping model to open the mapping editor.
  2. In the Mappings field in the mapping editor, click the View options icon and select the Mapping Groups menu option. The mapping editor changes to display mappings at the table level.
  3. Right-click on a mapping line and select the menu item for the type of expression that you want to create.

Feedback