Trouble Creating Relationships

HI all,

I've tried the solutions that I've found in previous tickets but it still won't work for me.

Everytime I want to create a relationship between the different sql tables I get the error:

You can't create a relationship between these two columns because one of the columns must have unique values

Ok what I want to do:

I've got 3 data sources, those are 3 different sql sources.

But they all got 2 items in common: the name of the analyst and the group.

So I want to create the relation ship for the name within those 3 tables, and for the groups.

Name is mentioned in red, group is mentioned in blue.

https://photos.app.goo.gl/mRk0HEJodQcKFlZL2

The name&group table has the analyst_name which contains the same names (and format of names) as Assignee (Tickets) and assignee_full_name (Changes).

The goup_name (Name&group) has the same names of the group (and format) as Group_name(Tickets) and group_name(Changes).

What I want to create:

- an visual report with some data from the tickets and changes table.

- possible to filter on the group-name and/or analyst name

I hope someone can give me an helpfull hand