Issue with People Table Missing Company Lookup in Account Table

Harshil B. · 2025-03-09T00:20:26.269165+00:00

I created an account table, and after that, I made a people table; however, the people table does not include a company table lookup.

To add a company table lookup to your people table: 1. Access the enrichment panel in your people table 2. Look for the "Lookup Single Row in Other Table" enrichment option 3. Add this as a column to your people table Once added, this lookup column will: ** Automatically link your companies and people data tables ** Allow you to extract corresponding company variables into your people table When you click on any row in the Company column, you'll be able to pull a lookup of all the fields from the company table for the relevant company. You can then select specific company fields to add as columns in your people table. Remember: Whenever you add new company data to your company table, you can rerun the lookup in your people table to refresh and pull in the updated company information.

Sources: Find People [Clay 101] - Clay University Enrich People (Waterfalls) [CRM Enrichment] - Clay University

3 comments