Takes one parameter, FieldName


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.


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

Sort "MemTab.Person.FirstName"

KeepUnique "MemTab.Person.FirstName"