Currently, Clay only supports deduplication based on a single column at a time. You can dedupe by:
1. Clicking on the column header you want to dedupe
2. Selecting "Dedupe" from the dropdown menu
3. Confirming which duplicate values to remove
Alternatively, you can enable auto-dedupe which continuously monitors a specific column for duplicates, keeping the oldest row and removing duplicates:
1. Open your table settings dropdown
2. Select "Enable auto-dedupe"
3. Toggle it on and select the column to use for identifying duplicates
For more complex deduplication needs involving multiple columns or sorting logic, you might need to use a workaround like merging columns first or requesting this as a feature enhancement.