I have a problem need help. I created one field collection (unlimited value) for content type. Then I create 1 views to ren value fields in tables. I created relationship field collection for the that views and have a problem that the fields of the node duplicate value by the number of the field collection values. How can I remove duplicate of the field value in that content type.
This worked for me i had movies and cast list so when i enabled the aggregation field all the actors of a movie in cast list were separated in different rows. In the Aggregation settings of the field(cast list) , choose aggregation type: group results together( which is by default) and group column : entity ID( by default it was target id) and your duplicates should be removed.