Forum Discussion
Error: this could be because there is missing intermediate data to connect the two columns
I have two tables. they both have a column with the same name. And the values in these two columns are the same. When I tried to link these two columns together I got an error: this could be because ...
One of the columns participating in relationship must have unique values and no nulls/blanks. You can create the lookup table:
1. Go to the "Edit Queries", duplicate one of your tables, rename it to "MyLookup" and delete all column except key/id column.
2 Remove the duplicate values and filter out the nulls...
3. Create 2 relationships - from each original table to the new lookup table.
This answer seems to depend on each table having a single unique key. My data is related by a set of columns (Segment, Product, Month). How can I implement this relationship?