I want to create a list of users (in a table format) which are associated to teams.
In the table, some users must have several related teams.

I have created a view of users with this settings:

1 > Add a relationship : The entity reference field of the users (in my team content type)
2 > Add the users fields : Name, firstname, phone....
3 > Add a node title field to display the names of the teams (with the relationship)

But, i get some duplicated users. If a user is associated with several teams, the user has several rows.
I want to have a row by user, with several teams (if necessary) in the teams column. (see image)
I have tested to reduce the duplications the aggregation option without success.

Can you help me to resolve this problem ?

Thanks for your help.


kumkum29’s picture

Issue summary: View changes
kumkum29’s picture

Issue summary: View changes
kumkum29’s picture


I have resolved my problem with the "Views Distinct" module and using "filter repeats" option on the mail.
But this module is installed only for this problem.
Can i get the same result with a query alter on the view (and groupby on mail) ?


RenatoG’s picture

Status: Active » Reviewed & tested by the community

Hi @kumkum29, how are you?

I was checking and using Views Distinct for this case is an good solution.

I tested and works good. It can help many people.

Thank you very much.

RenatoG’s picture

Status: Reviewed & tested by the community » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.