Lookup Records in Another Table: Add a column to cross check whether a field exists in any of your Clay tables (e.g. email, full name, company name or URL) to avoid duplicates.
1. Add the action
Add the Clay Lookup Record in Other Table to one of your two tables. If you have a masterlist you're checking against, we suggest using the non-masterlist one. Let's call it Table A.
2. Specify the inputs
Just select the Record Value you would like to lookup in your non-masterlist, Table A, and then identify the target base, table, and column you want to compare it against in Table B.
In this example we compare the Roam and Linkerd communities to find overlapping stargazers.
Write Records to Another Table: Send an individual record or list of records returned as data from any action into a whole new table by adding this column.
<aside> 🚨 Check out the full doc right here How do I write a list to another table?
</aside>