Archive

Archive

Remove duplicates but keep null

Is there a way to remove duplicates but keep nulls?

 

I need to keep null values because that indicates a certain client hasn't reached a stage of our onboarding yet, but if data needs to be run twice in one day for some reason I don't want it to remove the nulls or else that defeats the purpose.

 

Anyway, thanks!

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Comments

  • Hi,

    Is anyone able to help out with this request?


    Thanks,

  • Member

    Can try replace Null value with a dummy value of Row ID, for example, and use SQL DISTINCT to remove duplicates. Then deal with the dummy values... Make sense?

  • Member

    vote for this answer.

     

    Nulls --> unique dummy -->remove duplicates --> you can convert back to null 

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In