Forum Discussion

Gregwoolley2387's avatar
Gregwoolley2387
Regular Visitor
8 years ago
Solved

Relationship between tables

Hello    I have 3 tables of data that I'm looking to refer to. All of which have column for 'Year' and 'Scheme Name', amongst other data points.   I would like to be able to apply a slicer for 'Y...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Gregwoolley2387,

    I am unable to see the file you shared. In your scenario, if you get error message "You can’t create a relationship between these two columns because one of the columns must have unique values" when creating relationship, please review this blog to solve this issue.


    If you still don't get expected result, please share sample data of your tables for us to analyze.


    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Gregwoolley2387,

I am unable to see the file you shared. In your scenario, if you get error message "You can’t create a relationship between these two columns because one of the columns must have unique values" when creating relationship, please review this blog to solve this issue.


If you still don't get expected result, please share sample data of your tables for us to analyze.


Regards,
Lydia

Gregwoolley2387's avatar
Gregwoolley2387
Regular Visitor
8 years ago
Thank you Lydia. The blog was helpful.