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 on the history icon to choose parameters based on you previous actions. Note that only parameters applicable to the current dataset will be shown in the menu.

See also:

• Aggregate rows
• Select missing values