Preventing Deletion of Duplicate Rows with Mobile Numbers

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

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 S.
·
·
https://app.clay.com/workspaces/207112/tables/t_FOsoEHuQCF4Q/views/gv_cHw3v66dn7Mo
Clay Team
APP
·
·
Hi, thanks for getting in touch!
Nick S.
·
·
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 S.
·
·
I'm a little behind some deadlines, could you help me test Juan P.
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
:thumbsup_all:1
🙌1
Frederik H.
·
·
Interesting!
Nick S.
·
·
great workaround
Nick S.
·
·
Juan P. so the rows with the mobile numbers need to be at the bottom right?
Clay Team
APP
·
·
no, at the top
✅1