To “join” two CSV tables on a matching URL in Clay, use a lookup to pull columns from one table into the other. [1]
1.
Pick the table you want as the “base” (the one that will keep its rows).
2.
Add an action column: Lookup single row in other table (or Lookup multiple rows in other table if one URL can match multiple rows).
3.
Set:• Table to search = the other CSV table• Target column = the URL column in that other table• Filter operator = Equals (or Contains if URLs aren’t identical)• Row value = the URL column in your base table
4.
Run it, then use the matched row data to bring over the fields you need.
You can do this by creating a “base” table, filtering it to only rows that matched, then writing those rows into a brand-new table. [1] [2]
In your base table, add Lookup single row in other table (or Lookup multiple rows if one URL can match multiple rows). Match on your URL column using Equals (or Contains if needed).
Run the lookup, then filter the table to keep only rows where the lookup found a match (non-empty / match count > 0).
Use Write to Other Table to copy the filtered rows/columns into a new “source of truth” table.
If you need any more help with creating your new table or filtering matched rows, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific challenges you’re facing?