Clay Icon

How to Reference a Column from Another Table in Your Current Table

ยท
ยท

hi team - Can I directly reference a column from another table into my current table? In this scenario - I have a master company table which has a column called All News Summary Response that I need to bring into my people table And I cant seem to get lookup to work in this scenario - I need to use this column in an Anthropic email instruction

  • 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 Shwetha, thanks for reaching out. Taking a look at this now!

  • Avatar of Bruno R.
    Bruno R.
    ยท
    ยท

    The lookup single rows enrichment column will indeed be the best solution to pivot data between tables here. I recorded a video to show you how you can set this up specifically for your use case! https://www.loom.com/share/6f455c620b0e4cc8a7b7845fbc0a2873?sid=beeb0b1f-ea1f-4608-b582-3c9d0d10436d

  • Avatar of Shwetha R.
    Shwetha R.
    ยท
    ยท

    Awesome super helpful! thanks ๐Ÿ™‚

  • Avatar of Bruno R.
    Bruno R.
    ยท
    ยท

    Happy to help here! Will close this conversation now.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

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

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Thank you so much for sharing your feedback Shwetha R.!