Mapping Table Data to Existing Columns in Target Database

Garrett W. · 2025-11-04 23:18:18.069893+00

how do i send table data and map it to existing columns in the target table? this functionality no longer works the same way it used to 😞

Mapping Table Data to Existing Columns in Target Database | Clay

9 comments

· Sorted by Oldest

Clay Support
APP
·
·
The "write to table" feature has been updated. The old "Write to Other Table" is now deprecated and replaced with "Send table data."
To send data to your "Clay Businesses Scrape" table:
1.
Click Actions → Send table data while in your source table [1]
2.
Select "Clay Businesses Scrape" as your destination table
3.
Choose Send row method
4.
Map your columns (Company Name, # Employees, Industry, etc.) to the corresponding columns in the target table
5.
Click Save
If you're still having issues, try using Force Run in the table settings, or delete and recreate the affected column with fresh mapping.
Clay Support
APP
·
·
Is that what you were looking for?
Garrett W.
·
·
there arent columns to map to though!
Clay Support
APP
·
·
Sorry to hear you're having trouble with the column mapping. I’ll connect you to a human agent who can assist you further.
Intercom
APP
·
·
Clay Support is sharing a file with you.
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!
Loading attachments
Garrett W.
·
·
yes thanks!
Garrett W.
·
·
https://app.clay.com/workspaces/489571/workbooks/wb_0t2arrqCtReS5rdRzKF/tables/t_0t585oxpTxP4eW8Fvx4/views/gv_0t585oxhjawifNrASET
Daniela D.
·
·
Hey Garrett! Thanks for reaching out. Happy to help. To confirm, do you want to update existing rows with new data? That is, previously transferred fields (via the send table data integration)? To do this, you'll need to re-run previously updated rows with this setting enabled (see screenshot below). It looks like the destination table does not include any records from the source table and it's also missing a source column to indicate that the 'send table data" action was used. This would explain why existing rows are not being updated, because they no longer exist. Do you recall deleting any records or columns from the destination table?
Loading attachments
Clay Support
APP
·
·
We haven't heard back from you here, so we're going to go ahead and close this thread out.
Still need help here? Reply back and someone will jump back in.
Have a question thats not related to this thread? We recommend kicking off a new ticket in the support channel!

Clay Support
APP
·
·
The "write to table" feature has been updated. The old "Write to Other Table" is now deprecated and replaced with "Send table data."
To send data to your "Clay Businesses Scrape" table:
1.
Click Actions → Send table data while in your source table [1]
2.
Select "Clay Businesses Scrape" as your destination table
3.
Choose Send row method
4.
Map your columns (Company Name, # Employees, Industry, etc.) to the corresponding columns in the target table
5.
Click Save
If you're still having issues, try using Force Run in the table settings, or delete and recreate the affected column with fresh mapping.
Clay Support
APP
·
·
Is that what you were looking for?
Garrett W.
·
·
there arent columns to map to though!
Clay Support
APP
·
·
Sorry to hear you're having trouble with the column mapping. I’ll connect you to a human agent who can assist you further.
Intercom
APP
·
·
Clay Support is sharing a file with you.
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!
Loading attachments
Garrett W.
·
·
yes thanks!
Garrett W.
·
·
https://app.clay.com/workspaces/489571/workbooks/wb_0t2arrqCtReS5rdRzKF/tables/t_0t585oxpTxP4eW8Fvx4/views/gv_0t585oxhjawifNrASET
Daniela D.
·
·
Hey Garrett! Thanks for reaching out. Happy to help. To confirm, do you want to update existing rows with new data? That is, previously transferred fields (via the send table data integration)? To do this, you'll need to re-run previously updated rows with this setting enabled (see screenshot below). It looks like the destination table does not include any records from the source table and it's also missing a source column to indicate that the 'send table data" action was used. This would explain why existing rows are not being updated, because they no longer exist. Do you recall deleting any records or columns from the destination table?
Loading attachments
Clay Support
APP
·
·
We haven't heard back from you here, so we're going to go ahead and close this thread out.
Still need help here? Reply back and someone will jump back in.
Have a question thats not related to this thread? We recommend kicking off a new ticket in the support channel!