Duplicate

This Analytics Edge widget recognizes duplicate rows in your data and lets you choose whether to keep them, remove them or combine them.

Typically used to remove duplication in lists, it can also summarize your data for unique values in specific columns.

Select Columns – select columns by position (column letter), or By Name, Duplicate rows are rows with the same values in all of the selected columns.

Ignore case – when performing the duplicate check, match rows even if they have differing upper or lower case letters.

Ignore spaces – when performing the duplicate check, match rows even if they differ because of different spacing (leading, trailing or within the text).

Add Count column – add a column to the table, named ‘Count’, with a count of the number of rows that have been aggregated.

Duplicates – select to Keep all duplicate rows or Remove all duplicate rows, or to keep Aggregates for any rows with duplicate values in the selected columns. For text columns, the ‘All (list)’ option will contain a comma-separated list of all values.

Singles – select to Keep rows or Remove rows that do not have duplicate rows in the table.

Blog article: Using the Duplicates Function

Updated for v10.