Select duplicates

Selects rows with duplicate values, comparing them by the selected key columns.

Parameters:

Superfluous rows only - when checked, if duplicates are detected, one of the rows will remain unselected. This mode is useful for getting rid of the unwanted duplicates.

Click on the keyboard_arrow_down icon to access the following commands:

• Extract keys

Click the history icon to choose parameters based on your previous actions. Note that only parameters applicable to the current dataset are shown in the menu.

See also:

• Aggregate rows
• Select missing values