Clay Icon

Merging Two Tables from the Same Parent Company Table

Β·
Β·

hi, is it possible to merge 2 people's tables? the people I enriched are both from the same parent table too of companies

  • 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 Bruno R.
    Bruno R.
    Β·
    Β·

    Hi Jatin, thanks for reaching out. Taking a look a this now.

  • Avatar of Bruno R.
    Bruno R.
    Β·
    Β·

    Here’s an example of how you can pivot data between tables using a Lookup Single Row integration, which works similarly to an Excel vlookup. This feature allows you to merge data from two tables by pulling in matching records. For example, if Table A and Table B both contain records for the same company, the integration will identify the matching company name and bring relevant data from Table A into Table B. This ensures that related data from different sources is seamlessly consolidated into a single view, saving time and reducing errors. This method is especially useful for maintaining data consistency across multiple tables and enriching records with additional information. https://www.loom.com/share/ad767e3be9914d19a2f6647efe4dfa85?sid=b392b189-1b2a-4fba-a8dc-edb8032f79b1. You can read more about this feature in this docs page.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

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