Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Remove duplicates not working.. Can't create relationship

Hello,   I have a dataset with customer and a discount structure for that customer per part. I created a concatenate in the edit query screen of the customer, and there are a couple duplicates. Hig...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    v-sihou-msft

     

    Yes, I double and triple checked. Everything was done the same way as in my example. Must be an error due to such a large data set.

aar0n's avatar
aar0n
Advocate II
8 years ago

Another thing to look for - 

 

if you have "null" and blank values, it seems to treat them the same when you "remove duplicates".. but then it considers them not unique in the relationship view...

 

 

what i did that worked, was to click "remove duplicates"  - then inthe "Home" tab in the ribbon, click on the drop-down in "Remove rows", and click on "Remove Blank Rows".

 

after removing those blank rows, everything worked great for me!

 

 

  • ChrisNZC's avatar
    ChrisNZC
    Advocate I
    4 years ago

    Thanks, this works for me (in Apr 2022).
    Removing duplicates using PowerQuery's menus doesn't remove NULL values so "Remove Empty" on the row after removing duplicates solves the issue as mentioned by aar0n.