Forum Discussion
Cannot create relationship between two columns.
Hm, that's a bit strange.
Then trim and clean the column (s in both tables) as well - before removing duplicates. You find these commands under the lowercase.
could you have the same rules but in different cases? i am assuming you did the remove duplicates in Power Query? I think power query is case sensitive, however i could be wrong.. but its just a thought.
Yes, good thought, but takeing a look through, some do occur in lower cases, but are still unique.
The first few Characters in the string though are not unique, eg, QTIC06_CR_KONA_BOART + QTIC06_CR_KONA_KBETR + QTIC06_CR_KONA_KBRUE. Is there a limit on the lookup string value? So when judging if something is unique, its only looking at first 5 or 10 characters?
no i wouldn't think so. have you done a group by on the table with a count to double check there no duplicates?
Tried that just now (I hadn't before) and yep, no duplicates.
and the data types are the same?