Takes one parameter, FieldName

Description:

Each back-to-back Record whose Field value matches the previous Record's Field value will be discarded. The comparisons are case insensitive. An exact numeric comparison may be done by placing a leading # sign in front of the Field name.

This is typically used after using a Sort statement to ensure same-valued Records are back-to-back. However, you may wish to use more complex logic and sorting to take advantage of this KeepUnique's logic in order to only discard Records where sub-matches are found.

Although KeepUnique only takes one parameter it does consider WorkWith.

Example:

Rem 'Get all unique first names    
    LoadTable    "MemTab.Person"

    Sort         "MemTab.Person.FirstName"

    KeepUnique   "MemTab.Person.FirstName"
    
    'Display
    HtmlTable
EndRem