Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How do I remove duplicates in a column BUT retain the null and blank cells ?

I have a 3 columns of serial numbers, IMEI numbers and phone numbers. I want to remove the duplicates from each column BUT keep the BLANK and NULL cells. Is there a measure to remove the duplicates i...
Need Help
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

Anonymous 

can we do that in PQ?

select all three columns and remove duplicates.

banks334's avatar
banks334
Frequent Visitor
4 years ago

this usually works for me. It will only remove duplicates if all columns selected are exactly the same. So, if trying to remove duplicate ESN's or some unique number... it will still keep records with different name or whatever other colun you slect before clicking "remove duplicates"

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    4 years ago

    could you pls provide the sample data (not the screenshot) and the expected output?