Merging Two Tables from the Same Companies List in Data Processing

Mohammad R. · 2025-03-05 18:22:58.615732+00

Hello, I have two "find people" processes coming out of the same companies list, they are currently outputting into two separate tables. Is there a way to give them the same destination? if not, is there a way to merge two tables with identical columns?

Merging Two Tables from the Same Companies List in Data Processing | Clay

4 comments

· Sorted by Oldest

Channeled
APP
·
·
Yes, there are two ways to address your situation: 1. Same destination: You can use the find contacts search option in the enrichment tab and select to save the results into the same company table. This allows you to run enrichments for each contact found in one table. 2. Merge tables: If you already have two separate tables, you can use our "write to table" feature to merge them. Here's how: • Use the "write to table" integration to transfer data between tables. • Once the data is in your destination table, you can combine or merge data from different columns using the Merge Columns feature. • To do this, click Add Column, select Merge Columns, and input your formula to combine the desired columns. Both methods will help you consolidate your "find people" results into a single table.
Source: Write to Other Table | Documentation | Clay University
Mohammad R.
·
·
can you give me more information on how to do the first option? I did not see an option to pick a destination in the enrichment. For context i'm using the Find work email template
Channeled
APP
·
·
I apologize for the confusion earlier. The "Find work email" template doesn't have a direct option to save results into the same company table. Instead, you can use the "write to table" feature to combine your results. Here's how: 1. Run your "Find work email" enrichments as usual. 2. After enrichment, use the "write to table" integration to transfer the data to your desired company table. 3. In the destination table, you can use the Merge Columns feature to combine data if needed. This approach will allow you to consolidate your "find people" results into a single table, even when using the Find work email template.
Sources: Findymail integration overview | Documentation | Clay University Nimbler integration overview | Documentation | Clay University DropContact integration overview | Documentation | Clay University
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.

Channeled
APP
·
·
Yes, there are two ways to address your situation: 1. Same destination: You can use the find contacts search option in the enrichment tab and select to save the results into the same company table. This allows you to run enrichments for each contact found in one table. 2. Merge tables: If you already have two separate tables, you can use our "write to table" feature to merge them. Here's how: • Use the "write to table" integration to transfer data between tables. • Once the data is in your destination table, you can combine or merge data from different columns using the Merge Columns feature. • To do this, click Add Column, select Merge Columns, and input your formula to combine the desired columns. Both methods will help you consolidate your "find people" results into a single table.
Source: Write to Other Table | Documentation | Clay University
Mohammad R.
·
·
can you give me more information on how to do the first option? I did not see an option to pick a destination in the enrichment. For context i'm using the Find work email template
Channeled
APP
·
·
I apologize for the confusion earlier. The "Find work email" template doesn't have a direct option to save results into the same company table. Instead, you can use the "write to table" feature to combine your results. Here's how: 1. Run your "Find work email" enrichments as usual. 2. After enrichment, use the "write to table" integration to transfer the data to your desired company table. 3. In the destination table, you can use the Merge Columns feature to combine data if needed. This approach will allow you to consolidate your "find people" results into a single table, even when using the Find work email template.
Sources: Findymail integration overview | Documentation | Clay University Nimbler integration overview | Documentation | Clay University DropContact integration overview | Documentation | Clay University
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.