Clay Icon
Join the Community
02 Support

How to Extract Data from Company Table to Find People Table

Avatar of Amir D.Amir D.
·
·

Hi there, how can i extract data frrom my "find company table" into my "find people table" https://www.loom.com/share/0bee1b86af6f4156be2a7c9102194414?sid=b8500fe8-f306-404b-b0d5-6b4d02d8a919 (this loom shows my problem a bit better) Company table: https://app.clay.com/workspaces/261880/tables/t_CajdBwAUUxH5/views/gv_uANDbQ9rxisu Find people table: https://app.clay.com/workspaces/261880/tables/t_CdRGp6yyVRXb/views/gv_GXQCbPGkAt73 Thanks in advance

2 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    You can easily link your companies and people data tables using the "Lookup Single Row in Other Table" feature. Here's how:1. Your companies and people tables are automatically linked within the same workbook for easier management. 2. To pull company data into your people table: • Look for the column with the Clay Logo in your Find People Table • This column uses the "Lookup Single Row in Other Table" enrichment • Click on any cell to extract specific variables from your companies table 3. Whenever you add new company data to your company table, simply rerun the lookup in your people table to refresh the data. This allows you to access valuable company information like tech stack or employee growth for personalizing your outreach. Sources: Find People [Clay 101] - Clay University Enrich People (Waterfalls) [Automated Inbound] - Clay University Lookup Single Row in Other Table with Clay

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Amir D.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: