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:

  1. Go to the Transformations page.

  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. Go to the Transformations page.

  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 a transformation script using the collect instruction.

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