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

How to Combine Two Tables of Companies Without Duplicates | Clay

How to Combine Two Tables of Companies Without Duplicates

·

·

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

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