Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    v-sihou-msft

     

    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's avatar
yaelwass
Advocate I
9 years ago

I'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

 

 

tbauch's avatar
tbauch
Frequent Visitor
6 years ago

Had the same problem. Saw the post about case sensitivity with duplicate removing. Transformed column to all UPPERCASE. Removed duplicates (3rd time)... and then the relationship worked. Make sure everyone reports it so we can get this fixed! 

  • mpi_gov_vn's avatar
    mpi_gov_vn
    Frequent Visitor
    4 years ago

    This really should get more upvotes. My issue was due to incorrect cases, too. I transformed all values to UPPERCASE and things worked out!