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
re-run the company data column in the people table
alternatively do a lookup in the people table using company domain
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.