Clay Icon

Mapping Columns to Another Table in SQL: Aligning Values Easily

·
·

how do we map a column to another table but in line with values in that table (thought you could do it in write to other table but you can't it seems...)

  • Avatar of Mohan
    Mohan
    ·
    ·

    So what I want to do is copy the values in CLIENT COMPANY column for example in https://app.clay.com/workspaces/28547/tables/t_SYWlytE2BsPW/views/gv_6HlCRIOy1gGh into the apollo (9) table but they need to go in the rows where the company website in both tables match....

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Just saw this other thread!

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    That would be the Lookup by using a matching value in both tables to pivot that information over :)

  • Avatar of Mohan
    Mohan
    ·
    ·

    But the lookup cant pull the data into the other table it can just tell me if there are equivalent matches right?

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    You can also find the latest options, Lookup Row or Lookup Multiple Rows depending on the circumstance. Here's a video and our docs page for Lookup Record!

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    To clarify, the purpose of the lookup is actually to pull information based on a matching value, so you should be able to extract the cell details if there's a match :D

  • Avatar of Mohan
    Mohan
    ·
    ·

    Should I set the lookup in the table where I want to pull the data into or pull the data from?

  • Avatar of Mohan
    Mohan
    ·
    ·

    Just done it - i was trying it before but i was setting it up in the wrong table

  • Avatar of Mohan
    Mohan
    ·
    ·

    thanks bro can see it works now!

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Woooh!!