Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Clay Cup

Powered by Tightknit

Linking Company Table Data to Employees in Database | Clay

Linking Company Table Data to Employees in Database

·May 20, 2025 02:17 PM·

Does anyone know how I can copy data from a company table over to the corresponding people table that are associated with the respective company? Example below where I have the top competitors for each company but I want to carry that over to the different employees so it's linked to their name

3 comments

· Sorted by Oldest

kushagra t.
·
·
re-run the company data column in the people table
alternatively do a lookup in the people table using company domain
Channeled
APP
·
·
To sync data like shortlisted competitors from your company table to the associated people table in Clay, you can use the lookup feature. Here's how: 1. In your people table, you should have a column that's linked to the company table. 2. When you add new company data (like shortlisted competitors) to your company table, simply rerun this lookup column in your people table. 3. This process will pull the enriched company data, including the shortlisted competitors, into your people table. 4. Clay automatically links your company table to your people table, allowing you to extract company attributes directly into your people data. Remember to rerun the lookup column in your people table whenever you update information in the company table to ensure all data is synced. This method saves on data credits and creates an integrated dataset combining individual and company information.
Sources: Enrich People (Waterfalls) [Automated Outbound] - Clay University Find People [Clay 101] - Clay University Find People [Clay 101] - Clay University
❤️1
Sean H.
·
·
Thanks kushagra t. that worked!
🙌1