Drupal 7 views grouping and aggregation with recipe ingredients I'm using drupal 7 in conjunction with the recipe module, Every recipe has a number of ingredients that are stored as fields in the database. I'm trying to create an xml view (using views datasource) that lists all of the recipes, but also lists their ingredients. Here is my problem, rather than this;

&lt;node&gt; 
&lt;title&gt;The Title&lt;title&gt;
&lt;ingredient name&gt; Ingred 1&lt;ingredient name&gt;
&lt;ingredient name&gt; Ingred 2&lt;ingredient name&gt;
&lt;ingredient name&gt; Ingred 3&lt;ingredient name&gt;
&lt;node&gt;


the output I'm getting is this;

  &lt;node&gt; 
    &lt;title&gt;The Title&lt;title&gt;
    &lt;ingredient name&gt; Ingred 1&lt;ingredient name&gt;
  &lt;node&gt;

  &lt;node&gt; 
    &lt;title&gt;The Title&lt;title&gt;
    &lt;ingredient name&gt; Ingred 2&lt;ingredient name&gt;
  &lt;node&gt;

  &lt;node&gt; 
    &lt;title&gt;The Title&lt;title&gt;
    &lt;ingredient name&gt; Ingred 3&lt;ingredient name&gt;
  &lt;node&gt;


It lists it as three seperate nodes, even though there is only one node. I've tried using the "aggregation" settings but still no luck, any ideas?
I use the group by option in the Format settings.  If you group by the Title, then Exclude that field from display...you should end up with a list as you describe above.