Edit Data Set Mapping

Documentation WorkBench Workflows
1

Edit Data Set Mapping

To edit the Data Set Mapping, find the data set on the side bar and right-button click on it. If the data set is currently open, you will need to close it before editing the mapping.

A context menu will appear:

Mapping Button

Edit Data Set Mapping Context Menu

 

Click on 'Edit Data Set Mapping' to display the Data Set Mapping Editor dialog:

Data Set Mapping Editor

Data Set Mapping Editor

The buttons in the dialog enable columns to be mapped, unmapped, added, deleted and reordered:

map Map Adds the field to the column list.
unmap Unmap Removes the field from the list of columns.
reorderup Reorder up Moves the selected field up.
reorderdown Reorder down Moves the selected field down.

 

To unmap a column:

  1. Click on the column to select it.
  2. Click the unmap(unmap) button.

 

To remap a column:

  1. Click on the Data Set Column to select it.
  2. Click on the Data Type to show the Specify fields in the 'Fields' window.
  3. Click on the Specify field.
  4. Click the map(map) button.

 

To add a column:

  1. Click on the Data Type to show the Specify fields in the 'Fields' window.
  2. Click on the Specify field.
  3. Click the map(map) button.

A link (link) icon will appear identifying that the column and field are the same heading.

 

To reorder the columns:

  1. Click on Data Set Column to select it.
  2. Click the reorderup(reorder up) or reorderdown(reorder down) until the column is in the correct position.

 

Note: A field may only map once. Specify fields that are mapped display a green check mark next to their name in the Specify field list confirming that they are in use.