Join the Community

Home
Directory
Events

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps

Community Guidelines

Powered by Tightknit

De-duplicating Tables: Multi-Column and Sort Criteria Solutions

·

·

Hi Team - Is there a way to de-duplicate a table based on more than one column? Or by one column but with a sort criteria/logic on another column?

1 comment

Channeled
APP
·
·
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.
Sources: Table columns | Documentation | Clay University Table management settings | Documentation | Clay University Auto-update and Auto-dedupe Table