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.
yaelwass
Advocate I
Advocate II'm having the same issue but the data set is only around 2000 rows.
Note that there seems to be an inconsisencty in how case sensetivity is handled: the Remove Duplicates feature is case sensetive but the uniquemenss check done when created creating realationshiops between queries is not. To work around this I just format the key column in the query to UPPERCASE. But this is an aside, I'm getting the issue even though cases are the same
EduSurveys
Advocate II
Advocate IIThank you! This solution worked for me to transform the values to UPPERCASE.