Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

I can't remove duplicates.

I cannot remove duplicates.  I tried changing to uppercase and then removing duplicates.  It says I have 12056 rows and 12054 distinct values.  I tried filtering null values through the python script...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Yes.  I used trim and it worked,

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I found the duplicates.  I think deleting duplicates isn't working because it only deletes for the top 1000 rows in power query.

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous ,

 

Removing duplicates does not only apply to top 1000 rows. it applies to your whole table. top 1000 rows is only for preview. Try checking other columns those might be the cause of data duplicate.

 

Hope this helps.