Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Hire GTME Talent
Explore Events

Powered by Tightknit

How to Join Two CSV Files by Matching URL Columns | Clay

How to Join Two CSV Files by Matching URL Columns

·Feb 02, 2026 05:51 PM·

I have two CSVs I want to join them into a new table if the URL column in each CSV matches how do i do this?

6 comments

· Sorted by Oldest

Clay Support
APP
·
·
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.
Clay Support
APP
·
·
Did that answer your question?
Zain M.
·
·
can i create a new table as the source of truth as I only want matched rows?
Clay Support
APP
·
·
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.
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
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?