Automatically populate a mapping table

This reference explains how to create an enrichment script that will automatically populate a mapping table with data from a data extract.

Introduction

A mapping table is a table that links source values to target values. Mapping tables are used in enrichments. For example, you can use a mapping table to map country codes (e.g. DE) to country names (e.g. Germany) to include this new data in your data extract.

Mapping tables contain the following two columns:

• MATCH - Populate this column with the source values contained in a data extract (for example, DE).

• VALUE - Populate this column with target values to map on to the source values in the MATCH column (for example, Germany).

Use an enrichment script to update a mapping table with the latest data from a data extract. Once updated, all datastreams using this mapping table will have the latest values during the enrichment process.

Prerequisites

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

• Create a datastream.

• Create a mapping table.

• Find the name of the columns in the data extract that contain the data used to populate the mapping table.

Procedure

To create an enrichment script that automatically populates a mapping table with data from a datastream, 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 + Create enrichment.

3. Click Custom Script.

4. (Optional) To assign the enrichment to individual datastreams of your choice, follow these steps:

   1. In the Assign to section, select Individual datastreams.

   2. In the drop-down menu, select the datastreams to assign the enrichment to them.

5. (Optional) To assign the enrichment to all existing and new datastreams that belong to Datastream Types of your choice, follow these steps:

   1. In the Assign to section, select Datastreams Types.

   2. In the drop-down menu, select the Datastream Types to assign the enrichment to all datastreams that belong to these types.

   3. (Optional) In the Do not assign to these individual datastreams drop-down menu, select the individual datastreams that belong to the Datastream Types that you have selected, but you do not want to assign the enrichment to them.

6. Click Next.

7. In Select Instruction, enter and select map.

8. Fill in the following fields:

   Sourcefield

   Enter the name of the column in the data extract that contains the source values to populate the MATCH column of the mapping table.

   Fieldname

   Enter the value DeleteMe.

   This is a required field, but it is not used in this use case. This column will be removed using a separate instruction described in the following steps of this guide.

   Mapping

   Enter the name of the mapping table to be populated.

   Missing

   Select the create option to add missing values to the MATCH column of the mapping table.

   Errors

   Select the ignore option.

   Flush Table

   (Optional) Select this checkbox to delete all previous entries in the mapping table each time the enrichment script is run. This step ensures the mapping table is populated with only the latest data.

   If you want to only add the new values to the mapping table and keep the existing entries, leave this checkbox empty.

   Alternative

   Enter the name of the column in the data extract containing the target values that should be used to populate the VALUE column of the mapping table. This field has to be configured as a Python expression.

   For example, to populate the VALUE column with a value of the column date, enter the expression {date}. Alternatively, to populate the column with a value Invalid, enter the expression 'Invalid'.

9. Below the map instruction, click Add Instruction.

10. In Select Instruction, enter and select cutout.

11. In Fields, click Add.

12. In the drop-down field, select String and enter DeleteMe into the field next to it.

13. Click Next.

14. (Optional) In Enrichment name, rename the enrichment.

15. Click Create +.

As a result, the enrichment script is created and can be applied to the relevant datastream to update the mapping table. For more information on how to apply an enrichment script, see Applying a mapping enrichment to a datastream.