Create a Table object

Table objects are used like dictionaries in which key / value pairs are defined. During mapping in a DML project, 'found keys' are replaced by the defined values. When defining a Table, you create as many as columns you want.

The Key column is used for selection only. Examples for keys are currency codes or customer names. The Value column contains the data bound to the keys that you want to retrieve. Examples are exchange rates or specific customer IDs.

In addition to keys and values, the Table contains two columns that state the period during which each row is valid; these are Start Date and End Date.

To create a Table you follow these steps:

  1. In Mapping Services, click File > New > Table. Specify a name and a location for the Table. This name is the logical name that is used to reference a given Table.
  2. Mapping Services opens the Table editor where you define the key / value pairs and the validity dates.
  3. The Table Details contain the default validity dates which are automatically applied to all Table entries. You can modify these default dates by clicking on the button next to the date field.
  4. Select the check box Send Table contents to the server if you want to include the Table when you deploy the mapping project to the runtime environment.
  5. In the Table area of the editor, click on the green cross icon to activate a new line in the Table. Type in the Key and Value data into the Table. The default validity dates are automatically entered. If you want to change the validity dates for individual lines in the Table, just type in different dates directly into the Table.
  6. Add as many lines to the Table as you want. You can use the red cross icon to delete lines.
  7. Select File > Save, Ctrl+S or the Save icon from the toolbar to save the Table.

Related topics

Use Tables

Related Links