title: Handling Null using ConvertRecord in NiFi
body: <p>Is it possible to handle null (column does not exist in the CSV) using convertRecord or ant other processor?</p>
  
  <p>I have several CSv files coming in daily. But the problem the fields are not same in each CSv, Is there a way I can send 0 value into the database for all those fields which doesn't exist in the CSV. If yes please let me no how? Thank you.</p>
  
  <p>Ex: CSV1 has following field:
  Age,Name,Address,Value1,Value2,<strong>Value3</strong></p>
  
  <p>(<strong>Note:Value3 is not present in all CSV everytime, sometime it is present and sometime the column does not exist)</strong></p>
  
  <p>CSV2 will have following:
  Age,Name,Address,Value1,Value2</p>
  
  <p>And in database The table skeleton is as follows:
  <strong>Age,Name,Address,Value1,Value2,Value3</strong></p>
  
  <p>I don't want to have nulls followed by some value in the database. Is there a way my flow in NiFi can handle "null" and replace it with 0 before inserting into the database in an automated way (everytime if a specific field given in schema is not present in the CSV the flow should assign 0 to that field and ingest everything else in the database)</p>
  
  <p>Please help me achieve this. Thank you! </p>