Creating value tables

This guide explains how to create a value table to be used in a mapping table.

Introduction

A value table stores a set of target values to be used in a mapping table.

value tables are also used for the following purposes:

• Reference request URLs during bulk requests to Web Connect. For more information, see Web Connect reference.

• Manage input values (for example keywords) when configuring certain Datastream Types.

value tables are useful when defining certain values and prevent inconsistencies within your data.

For example, use a mapping table to map a country such as America to a country code such as US. However, America could be spelled as United States, U.S.A. or United States of America. Therefore, the value table allows you to define US as a target value for the names mentioned above. In addition, value tables allow you to define target values in one place to then apply across multiple mapping tables.

This guide will show you how to create a simple value table. For more information on configuring a value table further, see Advanced value table settings.

Prerequisites

Before you complete the procedure in this guide, perform all of the following actions:

• Create a mapping table to apply the value table to. For more information on creating a mapping table, see Creating and applying mapping tables.

Creating a value table

To create a value table, follow these steps:

1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Enrichments.

2. In the top right corner, click Value Tables.

3. In the top right corner, click + Create Value Table.

4. In Name, provide a name for the value table.

5. In the Value Table Entries section, click Add another Value Table Entry.

6. In the VALUE column, enter the target value to add to the value table.

7. (Optional) To add another entry to the value table, repeat steps 5 and 6.

8. Click Save.

As a result, the value table is created and can be used within a mapping table.

Populating a mapping table using a value table

To populate a mapping table using values from a value table, follow these steps:

1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Enrichments.

2. Under the page heading, click Mapping Tables.

3. In the top right corner, click + Create Mapping Table.

4. In Name, provide a name for the mapping table.

5. In Default Value Table, select the value table to use in the mapping table.

6. In the Mapping Entries section, click Add another Mapping Entry.

7. In the MATCH column, enter the source value.

8. Click Link to Value Table.

9. In the Tracking Value drop-down list, select the target value.

10. Click Set.

11. (Optional) To add another entry to the mapping table, repeat steps 6 to 10.

12. Click Save.

As a result, a mapping table is created using target values from the value table.

Automatically populating a value table

value tables can be automatically populated with values taken from a data extract. This feature is used to update value tables with the latest data.

To automatically populate a value table, create an enrichment script using the collect instruction.

For more information on how to create this enrichment script, see Automatically populate a value table.