Preventing Deletion of Duplicate Rows with Mobile Numbers

Nick S. · 2024-02-13T09:14:03.076137+00:00

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

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 T.

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 T.

APP

·

I think this will work

Clay T.

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 T.

APP

·

bf068743-f50e-4dd2-96e4-ad34cd5eab57.png(45 kB)

Clay T.

APP

·

Clay T.

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 T.

APP

·

no, at the top

✅1

14 comments