title: Processing a single group of rows at once in Talend Open Studio for Data Integration
body: <p>I have a data source where each row has five fields:</p>
  
  <pre><code>company name; year; code; value;
  </code></pre>
  
  <p>In my target output row model I want to produce a row like so</p>
  
  <pre><code>company name;year;value1;value2;value3;value4
  </code></pre>
  
  <p>Where value1,value..N are not concatenation for a single code but rather a "mapping". I.e. code 50 => "Total Revenues"</p>
  
  <p>So I need to perform the following logic:</p>
  
  <ol>
  <li>First select all the records for the same company name / year</li>
  <li>Then apply some custom java logic that performs the mapping between my codes and my fields of the output row.</li>
  </ol>
  
  <p>This is a in-memory map reduce with about 1M rows. How should this be handled in Talend Open Studio for Data Integration? </p>