Forum Discussion

Heinrich's avatar
Heinrich
Post Partisan
2 years ago
Solved

Data Modelling - find Duplicates

Hello I have imported 3 tables and wanted to do a 1:1 relationship It seems that there are duplicates. But the the connected columns should not have duplicates. How can I find the duplicates? Tha...
  • Ahmedx's avatar
    2 years ago

    You most likely have spaces at the end of your strings, and when you load them into the data model, the trailing spaces are removed from the strings.
    that's where the duplicates come from