Insert Company Data into People Table by Matching Records

Denis S. · 2025-12-17T08:21:10.668Z

How do take column data from company table to insert it as column in the corresponding people table, matching the company they were pulled from?

Insert Company Data into People Table by Matching Records | Clay

Clay Support
APP
·
·
Clay automatically links your company and people tables, making this super easy.
To pull company data into your people table:
1.
Click on any cell in your company column within the people table
2.
Hover over the company field you want (like company name, revenue, etc.)
3.
Click "Add as column"
This extracts the company attribute and adds it as a new column in your people table, automatically matching each person to their corresponding company data. Much more efficient than enriching each person individually!
Clay Support
APP
·
·
Was that helpful?
Clay Support
APP
·
·
If you need any more help with linking company data to your people table, please let me know. Would you like to provide more details about what you're trying to achieve so I can assist further?
Denis S.
·
·
I want to insert a column I have created in the company table. I can see the column I want to insert when I hover the company field and "Add as column" is displayed, but there is no content (while there is content in the column in company table).
Clay Support
APP
·
·
You need to re-run the company row in your people table to see the new column data.
When you add new company data to your company table, you'll need to rerun the lookup in your people table to pull that enriched company data over. You can always rerun the column linked to the company table to refresh and get the latest data.
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help with refreshing the company data in your people table, I’m here to assist. Would you like to share more about the specific steps you’re taking or any issues you’re encountering?
Denis S.
·
·
Ok problem solved.
Clay Support
APP
·
·
Great to hear that the problem is solved! If you have any more questions or need further assistance, feel free to ask.
Taimoor A.
·
·
use lookup \
Clay Support
APP
·
·
Yes, exactly! The lookup column is what connects your company and people tables.
When you add new data to your company table, just rerun that lookup column in your people table to pull the updated company data over. This refreshes all the linked company information for your contacts without using extra credits.
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you need any additional help with using the lookup column or refreshing your data, I’m here to assist. Would you like to provide more details about what you’re trying to resolve or understand?
Denis S.
·
·
Taimoor A. are you referring to Write to another table?
Clay Support
APP
·
·
"Write to Other Table" has been deprecated - we now use "Send table data" instead.
You can find this new feature under Actions → Send table data in your table. [1] It does the same thing but with improved functionality for transferring data between tables.

17 comments