Forum Discussion
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...
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.
Hello,
If you are removing duplicates from a text column (costumer) verify if you dont have upper and lower case letters on the same field.
I.e: "Customer1" and "customer1". If you remove duplicates, power query will consider them as unique references and wont remove any of the them. But while creating relationships you will get an error of duplicate values.
BR