collect

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).

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 Instruction 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.