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

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Transferring Data Between Tables by Company Name in SQL | Clay

Transferring Data Between Tables by Company Name in SQL

·Nov 18, 2025 09:52 PM·

Hello! I am trying to write data from a column in one table to another, which I get there is a prompt, but I'm not seeing a way for it to match by say, the company name to verify the information is going into the right spot. Any suggestions?

5 comments

· Sorted by Oldest

Clay Support
APP
·
·
To transfer data between tables with matching, use Send table data (Actions → Send table data) or the Write to Other Table enrichment. [1]
For Send table data: Select your destination table, choose which columns to send, and map them accordingly. When you first send a row, it creates a new row in the destination table; subsequent sends update that same row.
For Write to Other Table: You can map specific columns (like company name) from your source table to matching columns in your destination table. In Step 4 of the setup, select the columns you want to copy and match them to the appropriate columns in the destination table. [2]
Alternatively, use Lookup Multiple Rows in other Table from your source table to search the destination table for matching data points (like company domains) to ensure data goes to the right records.
Before diving deeper, try using Sculptor (top-right corner) to help build this workflow—it's free and can quickly set up the matching logic you need!
Clay Support
APP
·
·
Is that what you were looking for?
Carrie C.
·
·
unfortunately this doesn't quite cover it as the prompt doesn't provide a way to guarantee the data is being mapped to the correct column
Clay Support
APP
·
·
Sorry to hear that didn’t fully help. I’ll connect you to a human agent who can assist further.
Clay Support
APP
·
·
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
image.png(93 kB)