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 found a work around to this...
1. Duplicate the query with "Duplicate values"
2. Remove all columns except the one you want to be unique.
3. Group by.
4. Do a "Left Outer" Merge with the original Query