Show TOC

Background documentationMap Data Dialog Box Locate this document in the navigation structure

 

You use the Map Data dialog box to map the data fields from an input element to the fields of the data service. When working with a clustered dataset, you also map the nodes of the dataset. You map data fields to define which fields of the input data are the correct sources of data for the fields of the data service.

You display the Map Data dialog box by right-clicking a connecting line between an input element and the input port of a data service on the Design board and choosing Map Data from the context menu.

The Map Data dialog box contains the following items:

Item

Description

Toolbar

Displayed only when mapping data in a clustered dataset.

The Map Data dialog box toolbar contains the following buttons:

  • Unmap: Deletes the currently selected mapping. If you delete a parent node mapping, any relevant child node mappings are also deleted. If you delete a child node mapping, the parent node mappings are not deleted.

  • Map All: Automatically maps all child nodes of the selected mapped node, if the names are the same. (If you map a child node, the parent nodes are mapped automatically.)

Mapping area

Displayed only when mapping data in a clustered dataset.

The Source side of the mapping area displays the output node(s) of the input element, and the Target side displays the input node(s) of the selected data service.

You map the output node(s) of the input element to the input node(s) of the data service by dragging from the Source node(s) to the Target node(s). You can map multiple nodes in this way.

A mapping between nodes is indicated by a mapping line. The appearance of the mapping line changes according to whether the fields are mapped automatically or manually (a manual mapping has a diamond shape at the center of the line).

Target Field

Displays the list of fields for which the data service requires input. When working with a clustered dataset, the fields displayed depend on the mapping selected in the mapping area.

The field type (for example, string or date) is indicated by an icon next to the field name. More information: Define Data Dialog Box.

Assigned Value

Enables you to enter the values required by the data service as input. If the dataset is clustered, you can only enter values for nodes that you have mapped and selected in the mapping area.

You can enter values in one of the following ways:

  • Assign a field value: Select a field from the dropdown list in the Assigned Value field of the relevant row. The dropdown list contains fields of the same type as the target field type, which are located in the element used for input to the data service.

  • Define a dynamic expression: Select Define expression from the dropdown list in the Assigned Value field of the relevant row. Use the Dynamic Expression Editor dialog box to define an expression that returns a value of the same type as the target field type.

    More information: Dynamic Expression Editor Dialog Box

  • Enter free text: Type a value directly in the Assigned Value field of the relevant row.

Show All

Enables a scrolled display of the list of fields, if there are a large number of fields available.

Select mode

Specifies which data to copy from the source dataset at runtime:

  • All rows: Copies all rows from the source dataset to the corresponding rows in the target dataset.

  • Current data row: Copies the current row (row in which the cursor is located) from the source dataset to the target dataset.

  • Selected data rows: Copies the selected rows (highlighted rows) from the source dataset to the target dataset.