collect

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

This guide explains how to configure the collect instruction. To learn about another instruction, go back to the Available custom script instructions overview.

Introduction

Use the collect 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).

If the value table is to be populated with many values, it may take some time to fully populate. For example, a value table with 12,000-15,000 rows can take 60 seconds to populate.

Prerequisites

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

Creating a custom script transformation using the collect instruction

To create and configure a custom script using the collect instruction, follow these steps:

  1. Create a custom script transformation.

  2. In the Instructions step, select the collect instruction.

  3. To configure the custom script instruction, 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 transformation.

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.