I built a table pulling data from a phantombuster webhook. The webhook delivers the data all in one chunk so we set up a "send to other table" wich breaks the JSON into individual entries in the new table. That works really well, the only problem i habe its that there are a lot of duplicates in the import which is why i am curious if there is a way to eliminate duplicates already during the import from the source tableor to add another step that he only sends updated contacts to a new table which is then the output table with only unique entries? Then i can set up the enrichments in there
You can eliminate duplicates in Clay using several methods: 1. Use Auto-dedupe: Click the Auto-dedupe icon at the bottom right of your table, enable automatic deduplication, select the column to dedupe, and save changes. 2. Dedupe via column: Right-click the column you want to dedupe, then click "Dedupe > Delete Duplicate Row". 3. For sending only unique entries to a new table, use the "write to table" integration and implement the Lookup integration to check if records already exist.
Hey Hermann I noticed you reopened this ticket. Is there anything we can do for you?
Feel free to keep this conversation going or create a new ticket.
Hey Bo, no thanks a lot for your help! Appreciate the support!
Hi Hermann, I'm glad everything worked out! I'll go ahead and close out this ticket now, but don't hesitate to reach out again if you need any help in the future.
