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

Dedupe a Table Using Two Columns or Set Surrogate Key?

·

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

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

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