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.
I just had the same issue the error having duplicate values on the key I was using to connect two tables. I had removed duplicate values based on the key column and I was still not able to join the two tables together.
It turns out the problem was a null value in the key column. I did a row filter and removed the null value and the two tables joined together fine. The error message was misleading.