Can I write to a Clay table but specifically write values to existing...

Can I write to a Clay table but specifically write values to existing rows, ie find the matching row and then update the column mentioned with the value specified. In the attached, I know the Company HQ country in another table.

7 comments

Clay Team
APP
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Siddhant B.
·
No action needed: https://app.clay.com/workspaces/39601/tables/t_A2tGrv4ikYlJ/views/gv_E40wRhNY2518
Clay Team
APP
·
Hey Siddhant! To clarify, you're trying to append the data, right? The best way to do this is to use a lookup record integration since it would find the matching value in a row.Write to the table will always create a new record in your tables and can't find any matches. Let me know if you have additional questions!
Siddhant B.
·
Well, I want to "update" the field "Company HQ country" in table 2, from columns in table 1. The rows already exist in table 2 with a lot of existing content.
Clay Team
APP
·
Got it, yep. Lookup is the way to append/update that information when there's a match for let's say a domain or LI URL. I'll drop the video about the integration in case it helps- https://www.loom.com/share/72f4e67e20424ba7a784ca9a5056f1a9?sid=0194f8b1-d773-4aaf-a40b-dbb34c279656
Siddhant B.
·
·
Hi Arturo O. - thanks for this, but am actually looking for a way to "write" to another table, but instead of writing an entirely new row, I want to just write one column's value in an existing row. Does that make sense? Sort of like an UPDATE statement in SQL... :)
Arturo O.
·
·
It makes sense, and the Lookup Record would actually do that for you since appending data would be synonymous with the action you mentioned. Let me know if setting up an example of that would help determine if that's what you're looking for. Write to table only creates new rows and cannot update existing ones from another table.