Use Tables

Tables are Mapping Services objects that contain data for use in message processing within a DML Mppping Project. A Table object is a self-contained and reusable unit that you create, access, and work with in a WorkFolder.

Create Tables

You create Table objects in Mapping Services, in the Extended Object/Table folder located in the Mapping Project.

Retrieve Table data

To retrieve the data in a Table you use DML Table functions in DML expressions, for example in a Map or in a Validation Rule.

In general, you use the data in Tables to either:

  • enrich message data
  • validate message data

Table structure

Like any table, a Table object comprises vertical columns and horizontal lines. The intersection of a column and a line is a cell.

By default, when you create a new Table it is empty and you must add new lines. The lines you add have the following default columns:

  • Key: Every Table requires at least one Key column. The values listed in the key column are used by Table Functions as filtering criteria for data searches. You can additional Key columns to a Table in order to add selection criteria..
  • Value: Every Table contains at least one Value column. Value columns contain data that is available for retrieval by Table Functions, in order to enrich or to validate message data. You can additional Value columns to a Table.
  • Start Date: Contains a date expression that specifies the date from which the data in the Table line is valid.
  • End Date: Contains a date expression that specifies the end date at which the data in the Table line is no longer valid.

Related topics

Extended Objects

Create a Table object

Manage Tables

Use Table data to process a message

Use CSV Import/Export

Related Links