Solved: Data Modelling - find Duplicates

Heinrich · ‎09-11-2023

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?

Thank you very much

Heinrich

Ahmedx · ‎09-11-2023

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

View solution in original post

Heinrich · ‎09-11-2023

Hello

Thank you very much
I have done it with Excel.
There where some duplicates
Regards
Heinrich

Ahmedx · ‎09-11-2023

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