RemoveDuplicateRows
RemoveDuplicateRows Function
Remove duplicate rows from a table. Duplicates can be identified either across all columns or for the specified column(s). For each set of duplicate rows, the first entry is selected.
Syntax
RemoveDuplicateRows (table Table, scalar Column1, scalar Column2 ...)
Arguments
| Argument | Description |
|---|---|
table Table | A table of the tables to be used as source material |
scalar Column | Name of the column to use in checking for duplicate rows |
Examples:
RemoveDuplicateRows([[FusionTestTable]],null)
Removes duplicate rows that are duplicates in all columns in FusionTestTable.
RemoveDuplicateRows([[FusionTestTable]],'VarcharColumn', 'DoubleColumn')
Removes the duplicate rows that are duplicates only in the specified column(s) in FusionTestTable.