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

Explore Events
Clay Cup

Powered by Tightknit

How to Combine Two Tables of Companies Without Duplicates | Clay

How to Combine Two Tables of Companies Without Duplicates

·Jun 19, 2025 03:01 PM·

I have 2 tables with a list of companies, I want to compile them into a new table and make sure there are no duplicates. How can I do this?

1 comment

· Sorted by Oldest

Channeled
APP
·
·
You can combine two tables of companies and remove duplicates by: 1. First, duplicate one of your tables (click "..." next to table name > "Duplicate") 2. Use the "write to table" feature to transfer data from your second table to this new table: • Click "Add Enrichment" in the top right • Search for "Write to Table" • Map your data fields to the corresponding columns 3. Enable auto-deduplication: • Click the "Auto-dedupe" icon at the bottom right • Select "Enable automatic deduplication" • Choose the column to dedupe by (like company domain) • Click "Save Changes"
Sources: Auto-update and Auto-dedupe Table Write to Table [Clay 101] - Clay University Rename, Duplicate, Delete, Edit Description of Table