Forum Discussion
Create Relationship
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?
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.
1 Reply
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.