Eliminating Duplicates 


Eliminating duplicates means removing all duplicate rows from the returned data table. By duplicates we mean rows where all fields are identical to all fields of another row. Consider the following example:

Before removing duplicates

Name

Income

Smith

1200

Jones

700

Banks

700

Smith

1200

Smith

900

After removing duplicates

Name

Income

Smith

1200

Jones

700

Banks

700

Smith

900

  1. Create a new information link or edit an existing link (see Modifying an Information Link).

  2. In the Information Link tab, go to the Conditioning section.

  3. Click Distinct.

  4. Open or save the information link.

    Response: Duplicate rows will be removed from the data table returned by this information link when it is opened.

See also:

Creating an Information Link