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

Resolving Data Deletion When Merging Tables in SQL Queries | Clay

Resolving Data Deletion When Merging Tables in SQL Queries

·Dec 02, 2025 04:30 PM·

Hey I have an error. I want to fusion data from 3 different tables in one table. Some are coming from a "take action on this list" while others are coming from "write to other table". But when I do "take action on this list" -> send to table, it deletes the other data. What can I do? do it first?

3 comments

· Sorted by Oldest

Clay Support
APP
·
·
That's frustrating—the "Send table data" action creates a new row on first send, then updates that same row on subsequent sends, which overwrites your existing data. [1]
To combine data from multiple sources without overwriting:
• Use different destination tables first, then merge them using our Merge Columns feature
• Or use "Write to Other Table" integration (Add Enrichment > Write to Other Table) which allows better control over data mapping [2]
• Then consolidate using Merge Columns: Add Column > Merge Columns with your formula
This prevents the overwriting issue you're experiencing.
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help resolving the data fusion issue or want to explore other options, I'm here to assist. Would you like to provide more details about what you're trying to achieve so we can find the best solution?