Compose Data Insert Expression editor

The Compose Data Insert Expression editor is used to add value to the data insert 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 pane.

Compose Data Insert Expression editor views

General Layout

The Mapping field shows the mapping information that is currently being edited. The Value of target field has a drop-down list where you can select one of the targets in order to supply a target expression.

Input area

This contains the target value, or values, for the currently selected Value of target field and can be manipulated using the editor tools described below.

Operator buttons

The buttons on the right side of the screen contain the operators that can be inserted to 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 the box 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 selected function type. 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 Data Insert expression editor toolbar

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

Related concepts
Mappings
Related tasks
Developing mappings