Unique

Syntax

Unique              field_name

field_name: The name of a field to use for determining uniqueness. This command can be used multiple times to create a composite key.

Eliminates duplicate records from a list or export based on the values in one or more specified fields.

This is often used with the Export command to create unique lists for mailing or to generate a ZIP.DTA file for use with the Look Up command.

To export a list with only one entry per unique mailing address:

Export
Unique              LAST NAME
Unique              ADDRESS
Unique              CITY
Unique              State

To create a unique list of runners based on name and birthdate:

Export
Unique              LAST NAME
Unique              FIRST NAME
Unique              BIRTHDATE