Forum Discussion

avivba's avatar
avivba
Regular Visitor
9 years ago
Solved

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...
  • CahabaData's avatar
    9 years ago

    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.