Merging Company Analysis and Contact Data in Clay

·Nov 02, 2025 10:27 AM·

I have company specific analysis in one table and contact data in another table. How do I merge the two in Clay? Or Push columns from one table into another?

2 comments

· Sorted by Oldest

Bharat D.
·
·
If you have any unique fields in both tables, you can try lookup rows to pull the data into the pne table, e.g., website or company name.
Hasnain R.
·
·
You can do this by linking your tables in Clay using the Linked Rows feature. Just add a new column in your contacts table, choose Linked Row, and connect it to your company table using a matching field like company name or domain once linked you can pull in specific columns like industry, size, etc. from the company table into your contacts table automatically.

Bharat D.
·
·
If you have any unique fields in both tables, you can try lookup rows to pull the data into the pne table, e.g., website or company name.
Hasnain R.
·
·
You can do this by linking your tables in Clay using the Linked Rows feature. Just add a new column in your contacts table, choose Linked Row, and connect it to your company table using a matching field like company name or domain once linked you can pull in specific columns like industry, size, etc. from the company table into your contacts table automatically.