Creating value tables
This guide explains how to create a value table to be used in a mapping table.
Introduction
A value table is a list of values that you can use for various purposes in Adverity, such as populating mapping tables or configuring data collection settings.
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.
Creating a value table
To create a value table, follow these steps:
-
Go to the Enrichments page.
-
In the top right corner, click Value Tables.
-
In the top right corner, click + Create Value Table.
-
In Name, provide a name for the value table.
-
In the Value Table Entries section, click Add another Value Table Entry.
-
In the VALUE column, enter the target value to add to the value table.
-
(Optional) To add another entry to the value table, repeat steps 5 and 6.
-
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:
-
Go to the Enrichments page.
-
Under the page heading, click Mapping Tables.
-
In the top right corner, click + Create Mapping Table.
-
In Name, provide a name for the mapping table.
-
In Default value table, select the value table to use in the mapping table.
-
In the Mapping Entries section, click Add another Mapping Entry.
-
In the MATCH column, enter the source value.
-
Click Link to Value Table.
-
In the Tracking Value drop-down list, select the target value.
-
Click Set.
-
(Optional) To add another entry to the mapping table, repeat steps 6 to 10.
-
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.