I was having a problem using views in drupal. I was trying to display a list of users who have recently been active but i was getting duplicate results. I will show you my initial view design, show you the problem, and show you my solution. Hopefully it will be the same duplication problem you have been having because as I have searched for my solution, I have found MANY solutions which do not work and are for other views duplication problems.
Here is the layout of my original view
As you can see, this drupal view will display a grid of users who have had access to the site within 1 week, with the most recently active users appearing first.
But here was my problem… I was getting duplication. What was causing this duplication in views?
Well here was the problem… Each user was capable of creating multiple node types. Each user starts off with only a user profile (1 node). When that was the user’s only node, the results were fine and they only showed up once, there was no duplication. I added advanced forums and each forum topic is treated as its own node. Since “boon4376″ had created 2 forum topics and had a user profile, they had created a total of 3 nodes, and thus showed up 3 times on the activity view i created.
Why does drupal show activity by node owner and not by the user itself? I do not know. As shown in the picture below, the trick is to add a filter to the view to eliminate duplicate results.
 |
To get to this solution, click the “+” next to filters, select “node” as the criteria, and check “node type” as the type of specific node filter. In the image above, you can see how I filtered only to show activity for the User Profile node type as users can only have 1 user profile and thus can only appear once in the results. If I had selected “forum topic” as a node type, the user would show for each forum topic they started which would be a disaster.
As you can see filtering the view by node type removed duplicate results. This will not work in all duplication problems but it certainly solved mine. Hope this helps! 
Is User Profile a custom content type? I am having similar issues with duplicates but that Profile as a node type does not appear…
Yes, I have modules “profile” and “Advanced profile” installed. Under “content types” profile and User profile (uprofile) appear. Do you have both of those modules installed?
I have both of these modules installed and neither of them give me an option “user profile” in views’ node type. How did you do this?
i love you !
could you please help me? I don’t see the ‘user profile’ in views. I downloaded the advanced profile module and i already have profiles set up