Updating Existing Rows in Clay Table Instead of Adding Duplicates

I have a clay table i’m adding rows to with the “write to other table” feature i’m doing this multiple times, and instead of new rows getting added for the same rows I want the existing rows that were added earlier to be updated if the domain is the same for example, if the table contains xyz.com in it already, instead of adding another row to the table with the same domain, just update the same row with the new datapoint that is to be added how to do this?

3 comments

Kaushik K.
·
·
Clay S.
Channeled
APP
·
·
Currently, the "Write to Other Table" feature is designed to create new rows in the target table and doesn't have a built-in upsert (update/insert) functionality.For updating existing rows based on matching domains, you would need to use a different integration that supports upsert operations, such as: 1. Snowflake Integration - This allows you to: • Use a lookup field (like domain) as a unique identifier • Update existing rows if a match is found • Create new rows if no match existsIf you need to specifically use the current table setup, you'll need to implement additional data management strategies or consider reaching out to our support team for guidance on alternative approaches. Sources: Write to Other Table with Clay Labs Snowflake integration overview | Documentation | Clay University Upsert Row with Snowflake
Channeled
APP
·
·
Hi Kaushik K.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: