Clay Icon

Connecting People and Company Tables in Database Management

·
·

Hi everybody, I'm wondering if it's possible to connect 2 tables together:

  • one people table (with company name assigned per person)

  • one company table (with other criteria that I'd like to connect to the people table)

I cannot find online any resources about that - does anybody have experience doing this?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!

  • Avatar of Tanvi R.
    Tanvi R.
    ·
    ·

    Hi Juliette, thanks for reaching out and great question! You can absolutely connect your people and company table together using a Lookup Record in Single Row enrichment. Here's how: 1. In your people table add an enrichment column for "Lookup Record in Single Row" 2. In the input menu, select the name of the company table to Lookup in. Then select the Company domain (or company name if you don't have this) column in the company table, make the operator "contains", and match it to the company domain/name column in your people table 3. Save and run this enrichment on the first 10 rows to check if it's working correctly. If a record is found, it will return "1 Record Found" with an array of all of the columns in your company table. Here's a quick tutorial on how to set upLookup Integrations in your table. Let me know if you have any other questions! 😊

  • Avatar of Juliette L.
    Juliette L.
    ·
    ·

    Thank you! Tanvi R.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

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