Duplication in Views display [#1428508]

I added field collection field in a Views table view and what I saw was that for every collection data combination I would get duplicate of node with the collection fields data.
My goal of displaying the data is bit more complicated. I am aiming to make that every collection would have a type and that type would be treated a a field in display. It may sound messy so I try to give an example.
Data output as it is now:

*-------------------------------------------------------------------------------------*
|    Node title  |  Collection field 1 value        |    Collection field 2 value     |
*-------------------------------------------------------------------------------------*
| Node 1         |  value 1.1                       |   value 2.1                     |
| Node 1         |  value 1.2                       |   value 2.1                     |
*-------------------------------------------------------------------------------------*

Sensible data output :
Lets turn field 1 in some kind of key field with limited values (select field should be perfect)

*----------------------------------------------------------------------------------------------------------*
|    Node title  |  When collection field 1 value = 1.1   |  When collection field 1 value = 1.2           |
|                |   Collection field 2 value is:         |  Collection field 2 value is:                  |
*----------------------------------------------------------------------------------------------------------*
| Node 1         |  value 2.1                             |   value 2.2                                    |
*----------------------------------------------------------------------------------------------------------*

Here the keys work as fields.
This feature would be really nice addition to this modules functionality and it should not be hard to execute.

Comments

Comment #1

spessex CreditAttribution: spessex commented 17 July 2012 at 14:10

Did you ever manage to get around this as I am experiencing the same problem whereby all the fields are being duplicated (twice) in Views with the exception that one set of fields has the containing information whilst the other set are blank?

Comment #2

Danny Englander

(he/him)

CreditAttribution: Danny Englander commented 5 August 2012 at 16:43

I just ran into a need for the same type of display as stated above and I cannot find a solution. I thought grouping might work but it did not. My use case is I have a Content Type called "Webinars" and each webinar has a Field Collection that includes Presenter and Bio of the presenter. Each webinar can have more than one presenter. So for example if a webinar has two presenters, the same exact webinar displays twice in a View, one for each presenter. I also tried a filter and a Contextual Filter but no joy.