Create Relationship

[avivba]

I'm having a difficult time creating a relationship between two excel tables.

I created a column type at both table indcating if a task is a pilot, rollout, product or customer.

When I am traing to make a relation bettween the two I am getting an error meesage that "mast have a unique value"

Any sugesstion how to create this relationship?

[CahabaData · Accepted solution]

1 of the table columns must contain only unique values.

If your tables both have repeating values for valid purposes - you must create a new table with distinct values.

You then connect the 2 tables you have to this 1 distinct table rather than attempt to join them both together directly.