title: How to find average of two lines in NiFi?
body: <p>I need to find average of two values in separate lines.</p>
  
  <p>My CSV file looks like this</p>
  
  <pre><code>Name,ID,Marks
  Mahi,1,90
  Mahi,1,100
  
  
  Andy,2,85
  Andy,2,95
  </code></pre>
  
  <p>Now I need to store that average of 2 marks in database.
  "Average" column should add two marks and divide with 2 and store that result in SQL query</p>
  
  <p>Table:</p>
  
  <pre><code>Name,ID,Average
  Mahi,2,95
  Andy,2,90
  </code></pre>
  
  <p>Is it possible to find the average of two values in separate rows using NiFi?</p>