complains both columns contain duplicate values. at least one of the columns selected must contain only unique values to create a relation

[Mohamad Alkhatib]

when creating a relationship between two pivot tables it complains both columns contain duplicate values. at least one of the columns selected must contain only unique values to create a relation between the tables
both my tables contain a column called WellId (well name) with the same format (all text) and all with the same Caps
now in this column the WellId the names are repeated for different date values and other corresponding data
the only data repeated in my tables is WellId, the rest are different
How to create the relation between my two tables based on WellId?
Under Power Pivot I get no relations detected and this details:
"No relationships were detected. Fields might have been added to a PivotTable or PivotChart from tables that do not have a relationship defined in the PowerPivot window. Alternatively, the relationship might be too complex to be detected automatically. To continue, use the Manage Relationships dialog box in the PowerPivot window to create new relationships or edit existing ones."

 

[Mohamad Alkhatib]

I was trying to follow the guidance on:

but it didn't work: Still no relation between may main data tables!

 

[Mohamad Alkhatib]

Managed to solve it, by selecting WellId from WellId table and not WellId from the other tables.