views - remove duplicates based on field value Hi I have an order list created in views with 2 fields: order ID and order payment method. Each order can have multiple payment methods (every payment method gets own incremented id when attached to order).

Example:

order id1 with payment id1
order id2 with payment id2 and payment id3
order id3 with payment id4


This causes duplicate rows in second case. 

Problem: How can I show only orders with the last payment method attached to them?

One solution would be to create one view with order id argument, showing only one row and sorted by payment id descending. Then using views field view module and create another view with order list without duplicates. 

Question: is there a more simple solution without creating second view? Thank you.
I would use Views Distinct module to filter the duplicates out. The way this works is this:


you select the displayed view field,expand 'Views Distinct Settings' and select 'Filter Repeats'


So, for your particular case, if you want to show only the last payment method, order by payment method (ID ?) DESC, and on the order_id filter repeats. This way, only the last row for every order_id will show.