Clay Icon
Join the Community
02 Support

Preventing Deletion of Duplicate Rows with Mobile Numbers

Avatar of Nick S.Nick S.
·
·

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

14 comments

  • Avatar of Clay T.
    Clay T.
    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 😉

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Hi, thanks for getting in touch!

  • Avatar of Nick S.
    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?

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    I think this will work

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    can you test with a small sample in a separate table?

  • Avatar of Nick S.
    Nick S.
    ·
    ·

    I'm a little behind some deadlines, could you help me test Juan P.

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    ­

    bf068743-f50e-4dd2-96e4-ad34cd5eab57.png(45 kB)
  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    ­

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    this will work, dedupe will start from the bottom

    :thumbsup_all:1
    🙌1
  • Avatar of Frederik H.
    Frederik H.
    ·
    ·

    Interesting!

  • Avatar of Nick S.
    Nick S.
    ·
    ·

    great workaround

  • Avatar of Nick S.
    Nick S.
    ·
    ·

    Juan P. so the rows with the mobile numbers need to be at the bottom right?

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    no, at the top

    ✅1