I have a content type called “Stuff”. Which has a taxonomy term called “Area”. There are three Areas: A, B and C. I have a view that lists the content. The problem is, I get duplicates based if a node is assigned to multiple terms.
So for example, if I have three nodes, each assigned to ONE taxonomy term, I end up with:
Stuff 1 | A Stuff 2 | B Stuff 3 | C
But if I assign a node to multiple terms I end up with:
Stuff 1 | A Stuff 2 | B Stuff 3 | C Stuff 4 | A, B, C Stuff 4 | A, B, C Stuff 4 | A, B, C
I’ve tried:
- Going under ADVANCED –> OTHER –> QUERY SETTINGS –> DISTINCT …
Any ideas what could be causing this?
UPDATE
If I use aggregation, I get:
Stuff 1 | A Stuff 2 | B Stuff 3 | C Stuff 4 | A Stuff 4 | B Stuff 4 | C
But I want:
Stuff 1 | A Stuff 2 | B Stuff 3 | C Stuff 4 | A, B, C
What am I missing?