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.
Thank you ImkeF,
Compleated that, converted everything to Uppercase in both tables and removed duplicated in Column 1 in Excel 2 'RULE_NAME', still no luck in getting them to connect.
Would it matter if a value in Column 1 is also in Column 2 of Excel 2? Not all the rules have a translation, so the rule is just repeated in the translation column. If I remove them might that help?