Clay Icon

How to Properly Copy Company Descriptions to People Table in Database

ยท
ยท

Hi All, I'm trying to copy the company description from a company table to a people table. So far I've used 'Write to Other Table' to push through, but this doesn't match up the descriptions with the company name, it just adds the descriptions to a new row at the bottom. Is their an easier way to do this?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Instead of using "Write to Other Table," you can use the "Lookup Single Row in Other Table" feature, which automatically links your companies and people data tables. Here's how: 1. In your people table, locate the column with the Clay logo that shows the corresponding company name for each person 2. Click on any of those cells 3. Use the enrichment panel to extract the company description variable from your companies table into your people tableThis method ensures that the company descriptions will be properly matched with their corresponding companies since the tables are automatically linked when using Find People. Sources: Find People [Clay 101] - Clay University Find People [Clay 101] - Clay University

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

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