| Drupal

drupal remove duplicate views resultsWhen you are building a Drupal site and creating views, it's not uncommon to find that your view is showing the same result multiple times.

Here are two common ways to remove duplicate views results.

Option 1: Distinct

This is how Views describes the Distinct option:

"If there are multiple identical items, each will be displayed only once. You can use this to try and remove duplicates from a view, though it does not always work."

  • Open the Advanced area.
  • Next to "Query settings", click "Settings".
  • Check the boxes, "Distinct" and "Pure Distinct".

Option 2: Aggregation

Aggregration is often used to perform calculations on field data. For example, you can use Aggregation to count the number of content items in a particular content type. Or you could use it count the average number of comments on your content.

However, if the Distinct option doesn't work, we can use also try to use aggregation to remove duplicate items.

  • Open the Advanced area.
  • Next to "Use aggregation", click "No".
  • Check the "Aggregate" box.
  • On the left-hand side of the view, notice that "Aggregation settings" is now an option in several areas.
  • Click "Aggregation settings" for your Filter Criteria.
  • Choose "Count DISTINCT".
  • Click on the name of your Filter Criteria.
  • Choose "is equal to" and set "Value" to "1".

About the author

Steve is the founder of OSTraining. Originally from the UK, he now lives in Sarasota in the USA. Steve's work straddles the line between teaching and web development.