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.
For those who require a different solution, try using an R script to remove the duplicates.
I used the following script to solve the same problem:
output<-dataset[!duplicated(dataset$myColumn),]