Troubleshooting Table Sync Issues and Preventing Duplicates

I was updating a table (let’s call it Table 1), and I removed 4 columns that were used in a “Send Table Data” step to push data to another table (Table 2). After removing those columns, the sync broke. I deleted the old “Send Table Data” and made a new one, but now it’s duplicating rows in Table 2 instead of syncing with the originals. How do I fix this? Could you help me troubleshoot this? Please What’s the best way to update the Send Table Data in this case, so each row connects properly again? And is there a way to reverse this or clean up the duplicates easily?

5 comments

Elric L.
·
·
Table1: https://app.clay.com/workspaces/451915/workbooks/wb_0sxatjk4wHTzg9Rqipk/tables/t_0sxay42XCs9kVUbNkhW/views/gv_0sxay43ScRydfBj6FAv Table 2: https://app.clay.com/workspaces/451915/workbooks/wb_0sxatjk4wHTzg9Rqipk/tables/t_0sxatk5yzagmR985axu/views/gv_0sxatk59HYeARhm6vmV
Elric L.
·
·
more context: in table 2, I can’t clean up the duplicates manually since this table has actions tied to it, like creating leads in Close. I need to reconnect the rows properly before doing anything, otherwise it’ll just keep breaking things.
Elric L.
·
·
FYI I rebuilt my workflow between the 2 tables and reconnected everything manually. So I'm good for now.
Bo (.
·
·
Once data is sent using Send Table Data, it’s treated as a one-time push — deleting and re-adding it won’t re-link the rows. That’s why you’re seeing duplicates now. To fix this and reconnect the rows: ** Use a Clay Lookup from Table 2 back to Table 1. This lets you pull in updated or missing info without creating new rows. ** You can clean up the duplicates in Table 2 by filtering for the new ones (e.g. by timestamp or missing linked data) and deleting them. Let me know if you’d like help setting up the lookup or cleaning the duplicates.
Elric L.
·
·
thanks, I already rebuilt this from scratch.

Troubleshooting Table Sync Issues and Preventing Duplicates | Clay