Preventing Deletion of Duplicate Rows with Mobile Numbers

·

How can I avoid deleting duplicates rows if they contain a mobile number?

· Sorted by Oldest

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Nick Singh
·
·
https://app.clay.com/workspaces/207112/tables/t_FOsoEHuQCF4Q/views/gv_cHw3v66dn7Mo
Clay Team
APP
·
·
Hi, thanks for getting in touch!
Nick Singh
·
·
Would it work if I organize the list by mobile number so the rows with the values are at the top? and then the dedupe should get rid of the rows with empty values?
Clay Team
APP
·
·
I think this will work
Clay Team
APP
·
·
can you test with a small sample in a separate table?
Nick Singh
·
·
I'm a little behind some deadlines, could you help me test Juan Pizarro (Clay)
Clay Team
APP
·
·

bf068743-f50e-4dd2-96e4-ad34cd5eab57.png(45 kB)
Clay Team
APP
·
·
Clay Team
APP
·
·
this will work, dedupe will start from the bottom
🙌1
:thumbsup_all:1
Fred (Automindz Solutions)
·
·
Interesting!
Nick Singh
·
·
great workaround
Nick Singh
·
·
Juan Pizarro (Clay) so the rows with the mobile numbers need to be at the bottom right?
Clay Team
APP
·
·
no, at the top
✅1

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Nick Singh
·
·
https://app.clay.com/workspaces/207112/tables/t_FOsoEHuQCF4Q/views/gv_cHw3v66dn7Mo
Clay Team
APP
·
·
Hi, thanks for getting in touch!
Nick Singh
·
·
Would it work if I organize the list by mobile number so the rows with the values are at the top? and then the dedupe should get rid of the rows with empty values?
Clay Team
APP
·
·
I think this will work
Clay Team
APP
·
·
can you test with a small sample in a separate table?
Nick Singh
·
·
I'm a little behind some deadlines, could you help me test Juan Pizarro (Clay)
Clay Team
APP
·
·

bf068743-f50e-4dd2-96e4-ad34cd5eab57.png(45 kB)
Clay Team
APP
·
·
Clay Team
APP
·
·
this will work, dedupe will start from the bottom
🙌1
:thumbsup_all:1
Fred (Automindz Solutions)
·
·
Interesting!
Nick Singh
·
·
great workaround
Nick Singh
·
·
Juan Pizarro (Clay) so the rows with the mobile numbers need to be at the bottom right?
Clay Team
APP
·
·
no, at the top
✅1