1-to-1 relationship between columns with unique values not possible

[mateusz_ta]

Hello,

I have to tables:

T1 - calculated table, contains 1 column:

t1.col1: 1500 distinct text values

T2 - imported table, contains 2 column:

t2.col1: 3500 distinct text values

t2.col2: date table

I want to create a table visual containing t1.col1 and t2.col2.

But in order to do it I assume I need a one-to-one relationship between t1.col1 and t2.col2. But the only possible type of relationship is a one-to-many relationship. Why? Both columns containunique values.

[Idrissshatila]

Hello @mateusz_ta ,

if you couldn't make the relation as 1 to 1 then recheck the data because there's either duplicates in the manu table of there is blank values.

[MageVortex]

Typically I only have that issue when I have a repeated value, which often happens even when I think I have unique values, it also pops up a lot when I have a null value. 

To resolve this, I often export the data into excel to double check myself.

But if there are no null or unrealized repeats, I am of no assistance : )  Hope someone else is.

That said, if the alternate table only has a singular match, will a 1 to Many cause an issue?  It should serve to provide the same functionality under those circumstances I would think...