Combining and Updating Data from Multiple Source Tables to Central Table | Clay

Combining and Updating Data from Multiple Source Tables to Central Table | Clay

Channeled
APP
·
·
To combine data from multiple source tables into a central table and ensure updates modify existing rows instead of creating new ones, you have two main options: 1. Use the "Write to table" integration: • Click "Add Enrichment" in the top right corner • Search for and select "Write to table" • Select your destination table • Map the columns from your source table to the matching columns in your destination table • Enable Auto-update in the run settings to automatically process new data 2. Use the "Send table data" feature: • In your source table, click Actions → Send table data • Select your destination table • Choose "Send row" and select which columns to send • Click Save The key point: When you first send a row, it creates a new row in the destination table. For subsequent sends, it updates that same row rather than creating duplicates. For better data management, also consider enabling Auto-dedupe on your central table to automatically handle any duplicate entries.
Sources: Send table data | Documentation | Clay University Write to Other Table | Documentation | Clay University Auto-update and Auto-dedupe Table
Zachary K.
·
·
https://app.clay.com/workspaces/557947/workbooks/wb_ovTv7GQXo7JK/tables/t_0swhkmxWCtpefZ9o6Qb/views/gv_0swhkmxzEWreqZG8gkk
Zachary K.
·
·
When I use the "write to table" action, a new row is being created every time data changes. It is not in fact acting the way you describe: "he key point: When you first send a row, it creates a new row in the destination table. For subsequent sends, it updates that same row rather than creating duplicates."
Valentin G.
·
·
+1 - I'm struggling with the same thing
Zachary K.
·
·
Valentin G. - Just spent time with someone from support. They are digging into the error more
Zachary K.
·
·
They did confirm that the "Write to Table" action is legacy and the expectation is that it'll always create a new row
Zachary K.
·
·
The support AI must just be confused
Valentin G.
·
·
Ah well..
Valentin G.
·
·
I tried a workaround with "Lookup multiple rows from another table" however I keep getting "Invalid input" as a result. you know what thats about?
Loading attachments
Zachary K.
·
·
I haven'y run into that issue. But would that workaround really work?
Valentin G.
·
·
Not sure, it definitely hasn't for me. Maybe you could try? Or what are your doubts
Zachary K.
·
·
Are you thinking it would work like this:
Zachary K.
·
1.
New row on a "source" table
2.
Look up ID on "central" table
3.
If ID isn't found, use "Write to Table" action
4.
If ID is found, do what??
a.
As far as I can tell there's no way to append
Valentin G.
·
·
Would need to append using merge columns
Valentin G.
·
·
but yeah, I didn't get that far in the logic yet, since I failed step zero of even being able to look it up