How to Write Data from One Table to Another: Expert Advice Needed!

Kenan K.

I need help writing data from one table to another. There's something I'm clearly not getting right. Please advise!

✅1

24 comments

Kenan K.
·
·
I'd like to write from this table - https://app.clay.com/workspaces/23827/tables/t_52c5ZBJk7kfU/views/gv_eWpjpr1BYECo to this table - https://app.clay.com/workspaces/23827/tables/t_hL6ylbi5B2b5/views/gv_LEpI3b3GNDff
Kenan K.
·
·
The columns I'd like to write to other table are: First name, Last name, Domain, Legal Name, People LinkedIn URL, Claygent Identifier and Role
Kenan K.
·
·
Hello! can someone attend to me?🙏
Clay T.
APP
·
·
Hey there Kenan sorry for the delay, taking a look.
Kenan K.
·
·
Thank you Luis
Kenan K.
·
·
I followed the tutorial and even tried the CSV route, still didn't work
Kenan K.
·
·
Downloaded as a csv file and uploaded to the new table and it didn't populate
Clay T.
APP
·
·
Quick question Kenan, can you send another link for the second table, when I click on the link it tells me it doesn't exist
Kenan K.
·
·
Oh sorry I created a new one, a moment please
Kenan K.
·
·
https://app.clay.com/workspaces/23827/tables/t_VL14mSDkvxhy/views/gv_QZlHufsQPQzt
Kenan K.
·
·
There it is..
Clay T.
APP
·
·
Thank you
Clay T.
APP
·
·
Sorry for the delay, still working an the solution
Kenan K.
·
·
Ok
Kenan K.
·
·
thank you
Kenan K.
·
·
Clearly something's wrong right
Kenan K.
·
·
?
Clay T.
APP
·
·
Alright I got the values over. So "Write to Table" cannot write over columns of data, it can only write over lists within cells.
Clay T.
APP
·
·
In a situation were you want columns of data moved over you need to use the "Lookup Multiple rows in other Table" as that will link the tables together and then you can pull data over to another table.
Kenan K.
·
·
Thank you so much Luis
Kenan K.
·
·
Can you share a link to a tutorial on how to do this
Kenan K.
·
·
?
Clay T.
APP
·
·
Here's a video tutorial on how the integration works. Just a heads up that integration went through a name change recently, so the video will show the integrations old name. https://www.loom.com/share/72f4e67e20424ba7a784ca9a5056f1a9
Kenan K.
·
·
Thanks A lot, Luis