How to Dedupe and Remove Duplicates Across Tables in a Workbook

Enoch

is there a way to dedupe and delete duplicates across tables within one workbook? cc Jairo P. Juan O.

11 comments

Channeled
APP
·
·
Currently, deduplication in Clay can be done within individual tables in the following ways: 1. Using Auto-dedupe: • Enable automatic deduplication through the table settings dropdown • Select a specific column to monitor for duplicates • The system will retain the oldest row and remove duplicates 2. Manual column deduplication: • Right-click the column header you want to dedupe • Select "Dedupe > Delete Duplicate Row"Important notes about deduplication: ** Deleted rows cannot be recovered ** Duplicates are identified by exact string matches ** Deduplication is case-sensitive ** Extra whitespace is considered in matchingThere isn't currently a feature to deduplicate across multiple tables within a workbook simultaneously. You'll need to perform deduplication for each table individually. Sources: Auto-update and Auto-dedupe Table Table columns overview | Documentation | Clay University Table management settings | Documentation | Clay University
Channeled
APP
·
·
Is that what you were looking for?
Channeled
APP
·
·
Looks like you're still looking for help. If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
LuisArturo
·
·
Hey there Enoch thanks for reaching out, currently there is no way to dedupe multiple tables across a workbook. The best alternative would be to use a Lookup Row in other table inside of the tables where you wish to dedupe and then using filter which can be found in the upper left-hand side of the table, you can filter based on the positive results of this Lookup and then delete these rows.
Jairo P.
·
·
Understood. Is there a link where I can see a step by step on how it'd be done?
LuisArturo
·
·
Currently making a loom for this
Jairo P.
·
·
thank you!
LuisArturo
·
·
Here you go: https://www.loom.com/share/15224bb5f8e844c2939066c61559f68a?sid=2ade11b7-9122-4c96-91a1-e84108b23fba
Jairo P.
·
·
thanks a lot!
Channeled
APP
·
·
Hi Enoch! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Enoch!

How to Dedupe and Remove Duplicates Across Tables in a Workbook | Clay