title: How I Group by using awk
body: <p>Good afternoon</p>
  <p>I get a file with this structure:</p>
  <pre><code>$ cat test
  LogStartOffset,alex,1,4
  LogEndOffset,alex,1,4
  Size,alex,1,0
  LogStartOffset,alvaro1,1,2
  LogEndOffset,alvaro1,1,2
  Size,alvaro1,1,0
  LogStartOffset,alvaro_prueba,1,0
  LogEndOffset,alvaro_prueba,1,0
  Size,alvaro_prueba,1,0
  LogStartOffset,arquitectura_jenkins_creardocumentacion,0,348
  LogEndOffset,arquitectura_jenkins_creardocumentacion,0,387
  Size,arquitectura_jenkins_creardocumentacion,0,11011
  LogStartOffset,alex,0,445
  LogEndOffset,alex,0,498
  Size,alex,0,54670
  ...
  </code></pre>
  <p>Where:</p>
  <pre><code>  the field 2 is the topic name
    the field 3 is the partition of the topic defined in the field 2 
    the field 1 is the characteristic of the topic and its partition 
    the field 4 is the value of the charasteristic. 
  </code></pre>
  <p>For now I am working with 3 characteristics (maybe in the future it will be more): LogStartOffset, LogEndOffset and Size</p>
  <p>I want a output file with this structure</p>
  <p>topic,partition,LogStartOffset's Value,LogEndOffset's Value,Size's Value</p>
  <p>So the file.out should be something like this:</p>
  <pre><code>topic,partition,LogStartOffset's Value,LogEndOffset's Value,Size's Value
  alex,1,4,4,0
  alvaro1,1,2,2,0
  alvaro_prueba,1,0,0
  arquitectura_jenkins_creardocumentacion,0,348,387,11011
  alex,0,445,498,54670
  .....
  </code></pre>
  <p>The idea is group by fields 2 and 3 (Topic and partition), because I don't know if the secuence of the field 1 is always the same.</p>
  <p>I want to do it using awk but I don't know how to plan the grouping of fields 2 and 3 and regroup the data to have the desired output.</p>