.png&w=3840&q=75){kind=logo}
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...)
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....
Just saw this other thread!
That would be the Lookup by using a matching value in both tables to pivot that information over :)
- Mohan··
But the lookup cant pull the data into the other table it can just tell me if there are equivalent matches right?
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!
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
- Mohan··
Should I set the lookup in the table where I want to pull the data into or pull the data from?
- Mohan··
Just done it - i was trying it before but i was setting it up in the wrong table
Woooh!!