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