User GuideReference ManualIntegration Scenarios
 

2.1.3. Lookup Tables

See: Managing Channels - Basic Channel Functions

Lookup tables are tables of values used in message transformations that require the replacement of incoming values by corresponding outgoing values

The message transformation step can look up an incoming message value in this table and replace it with the matching value in the outgoing message. There are tools to create -either manually or automatically through import functions-, append, manage and share these lookup tables allowing you to centrally manage these tables and reuse them across channels and accounts.

To create a new lookup table click on the

The Manage Lookup Mapping Tables as illustrated below:

Manage Lookup Mapping Tables Link

Figure 2.2. Manage Lookup Mapping Tables Link


In the List of Lookup Mapping Tables page you can search for existing objects or create new lookup table by click on Add table command as illustrated below:

Add Lookup Mapping Tables

Figure 2.3. Add Lookup Mapping Tables


Clicking on Add table command will open the Add table screen ,you should type the table name and columns like illustrated below:

Add Lookup table parameters

Figure 2.4. Add Lookup table parameters


You can add entry to lookup table by Automatic Population of Lookup Tables or either by manually as illustrated below:

To add entry click on Add command and type your values in this screen

Add Lookup table entry

Figure 2.5. Add Lookup table entry