How to Transfer Deduped Contacts to a New Company Table

Dulan P. · 2025-03-05T21:24:28.074742+00:00

What would be the simplest way to transfer a column that is deduped to a new different table? Ex - We are starting with a contact list in this instance. We have a contact table that has many a number of contacts from the same company. We want to use this contact table to create a company table that has a list of the individual companies in a seperate table?

Here's how to create a separate company table from your contact list: 1. First, deduplicate the company names in your contact table: • Click on the company name column header • Select "Dedupe" from the dropdown • Confirm the duplicates you want to remove 2. Then use the "Write to Other Table" integration to transfer the data: • Select your Clay account • Choose or create your destination company table • Select the deduped company name column • Map the company data to your new table columns You can watch this process in action through this video tutorial: https://www.loom.com/share/1ae0bfb385094e9d98a8e22f7ed99c40

2 comments