Forum Discussion
Solved
Cannot create relationship between two columns.
Hi, I have two Excel tables, one with the master data and one with translations for rule violations. In Excel 1, I have a colume that lists the error causeing the load violation in each indiv...
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.
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?
Yep, Both Text.