Trying to make a connection from a data table to a lookup table. Everytime I do I get the following message: "The relationship cannot be created because each column contains duplicate values. Select at least one column that only contains unique values."
I cannot find any duplicate values in the look up table column. I have even gone to the data source (excel worksheet) to run the delete duplicates function and it says no duplicates found. I also initially found an empty row in the table and deleted it and then reloaded the data. It showed one less row was loaded from before so that row is no longer in the data model but still getting the error. This is a text column to text column lookup. Help!
I cannot find any duplicate values in the look up table column. I have even gone to the data source (excel worksheet) to run the delete duplicates function and it says no duplicates found. I also initially found an empty row in the table and deleted it and then reloaded the data. It showed one less row was loaded from before so that row is no longer in the data model but still getting the error. This is a text column to text column lookup. Help!