Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Hire GTME Talent
Explore Events

Powered by Tightknit

Dedupe a Table Using Two Columns or Set Surrogate Key? | Clay

Dedupe a Table Using Two Columns or Set Surrogate Key?

·May 26, 2025 04:25 PM·

Hey team. I was wondering if it was possible to dedupe a table based on two columns or should i be setting a surrogate key for that?

1 comment

· Sorted by Oldest

Channeled
APP
·
·
Currently, Clay's deduplication features only allow you to dedupe based on a single column at a time. You have two options: 1. Create a surrogate key by combining the values from your two columns into a new column, then dedupe based on that combined column. 2. Use the manual column deduplication method by clicking on your chosen column header, selecting "Dedupe" and then "Delete Duplicate Row." Alternatively, you can enable auto-dedupe for continuous monitoring of a specific column. This feature retains the oldest row when duplicates are detected. Keep in mind that deduplication is case-sensitive and considers whitespace, so exact string matches are required.
Sources: Table columns | Documentation | Clay University Auto-update and Auto-dedupe Table Table management settings | Documentation | Clay University