How to Use Lookup and Write New, Unique Rows to Another Table

[Write to Other Table] I have figured out how, in conjunction with lookup, I can get it to write new (unique) rows to another table. BUT If I want to look across 2 tables, and where rows match, to pass col information from 1 table to another

✅1

7 comments

Clay Team
APP
·
·
Let me know if you were able to set this up or if you ran into issues!
Ian M.
·
·
Hi Arturo O.... not cracked it yet. And so could do with some help. Its 11pm here and I am exhausted, can we connect in 7 hours please?
Ian M.
·
·
An example to look at would be the SEA Master People Table https://app.clay.com/workspaces/109036/tables/t_CPXPmhoyy0Sq/views/gv_uzTRayKjpvKv Where I have cols Source and "OK To Market" which I would like to "match and transfer) to the 2024-01-02 Global_Company_Master_Table
Clay Team
APP
·
·
Yep, will check it out and find the best value to match/establish a connection with.
Ian M.
·
·
This is another table, I want to do the same with https://app.clay.com/workspaces/109036/tables/t_UBofBugfcPDR/views/gv_HeaMogiX8UC3 ie Match via website URL and add the Mailchimp, Client Stop List, Source and LISN flags to the matching rows
Ian M.
·
·
I'll get up early tomorrow so I can catch you at a decent time
Ian M.
·
·
Hi Arturo O., was just on a call with Patrick and he showed me how to do this. So I am all good now thanks!
:sparkles-clay:1