i need to find average of two values in seperate lines. My Csv file loo like this.,
Name,ID,Marks Mahi,1,90 Mahi,1,90 Andy,2,100 Andy,2,100 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 Table: Name,ID,Average Mahi,2,90 Andy,2,100 Is this possible to find average of two value's in seperate rows using NiFi?
