Join the Community

Auto-Dedupe: Options to Delete Old Rows for Duplicates

·

·

1.
Is there any option for auto-dedupe to delete the old row instead of the new row, if there is any duplicate, or completely remove the processed job rows?
2.
If auto-dedupe function is set to off, I want to apply lookup to show me the latest results instead of the first/old one (not the sorting/filter work). and also show me that when it was contacted last time. How can I set this up?

Example: I have a jobs table, auto-dedupe is off, now there are multiple companies having multiple jobs. Day 1, I contacted a company regarding their job. Day 31st the company posted again. Now I want to contact the company on latest job post instead of that posted on Day 1. If I turn auto-dedupe on (job linkedin url) and the link is same, it will remove the new result and keep the old result. I want to bring in the new result and delete the old result. If the old result can not be deleted, I am applying a Lookup (multiple) to search for all the jobs of that company in the same table and I went I want to select "add as a column", I can not get the same results for each company because one company might only have one job and the other company might have 5 or 10 jobs. so the resulting value varies and I also want it to show me that when it was contacted last time. for the support, here's the link: https://app.clay.com/workspaces/236286/workbooks/wb_2Td26Mt2Tb3X/tables/t_EKUUeQGNEr4M/views/gv_EnBNXJonG2ht

10 comments

Bruno R.
·
·
Hi Fahad, thanks for reaching out! Good news, Clay tables have a native auto-dedupe feature which should be turned on by default. If not, by turning on auto-dedupe in your clay table, which can be set up across a number of deduplication parameters. Here's how you can do this: https://downloads.intercomcdn.com/i/o/1140444503/13040b7166bf91139781adf3/CleanShot+2024-08-09+at+13_54_07.gif?expires=1730303100&signature=75c64245a968676b1e045bff27df397d4fe01b8ef391c6469cf89c64a70428ff&req=dSEjFs16mYRfWvMW1HO4zU%2FZK1Fna5Vgja5u6FVZLS6YRg%3D%3D%0A I hope this was helpful. If there's anything else I can assist you with, please let me know!
Fahad T.
·
·
Hey Bruno, thanks for getting back. I am well aware of this. This feature by default deletes the new duplicated row. I want to delete the old row and keep the new one.
Bruno R.
·
·
There's no way to selectively deduplicate rows here, but I can try to see if there's a workaround for your specific use-case. Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1730304000&signature=2ba39f28f5bc2be62ee5e40e17679de4baa6426263569496c0beafdefdf92768&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSv%2FBpMW2BKsam%2FhVPuBGQ%3D%3D%0A
Fahad T.
·
·
sure here is the link https://app.clay.com/workspaces/236286/workbooks/wb_2Td26Mt2Tb3X/tables/t_EKUUeQGNEr4M/views/gv_EnBNXJonG2ht I also did a workaround for this, not yet completed, but almost working.
Nicolas P.
·
·
If you sort your table from new to old, wouldn't it delete the older one?
Fahad T.
·
·
Nope, it will only sort it out. Even if I filter it, it will hide the rows. Consider where there are thousands of rows, and multiple team members, you can not apply this manual condition every time.
Nicolas P.
·
·
I mean having it always sorted by date, new to old. That way, when de-duping, the first result -the one that is NOT deleted- is the newer one
Fahad T.
·
·
It dedupes by "date created". so If I created one row on Day 1, and duplicated row on Day 7, even if I sort them new to old it will delete the row of Day 7
👎1
Bruno R.
·
·
Hi Fahad, that’s correct! Were you able to get it up and running?
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.

Auto-Dedupe: Options to Delete Old Rows for Duplicates | Clay