collect

Populate a value table using values from a column in a data extract.

Introduction

Use the collect enrichment instruction to populate a value table using values from a column in a data extract. This instruction creates a distinct list (a list with duplicates removed).

Prerequisites

Before using this enrichment instruction, create a value table to populate. For more information on creating a value table, see Creating value tables.

Creating the enrichment

For more information on creating an enrichment, see Using custom scripts.

Configuring the enrichment

To configure the enrichment, fill in the following fields. Required fields are marked with an asterisk (*).

Column*

Enter the name of the column in the data extract that contains the values with which to populate the value table.

Table*

Enter the name of the value table to populate with values from the data extract. Create the value table before running the enrichment.

Flush

If the value table already contains values, select Flush to remove the existing values from the table before populating the value table with new values. If left unselected, the values from the data extract are added to the bottom of the value table.

If Flush is left unselected, duplicated values may be added to the value table.