title: perform Regex on JSON data across each row and push into the MySQL table using NiFi
body: <p>I want to achieve the following use case:</p>
  
  <p>I have a file as follows:</p>
  
  <pre><code> enter code here
  {"FirstName":6785,"Lastname":"Charles","Address":"1103 pioneer St"}
  {"HouseName":67783,"Lastname":"Stevenson","Address":"Abel St"}
  {"FoodName":7473,"Lastname":"luther","Address":"Half Moon Bay"}
  </code></pre>
  
  <p>si I want to add "NAME" and "Value" tag in the first column across each row so I can easily push all the FirstName, HouseName, and FoodName attributes under one column in MySQL named '<strong>Name</strong>' and its respective values under "Value" column in MySQL. for example I want the data to look like as following:</p>
  
  <pre><code>{NAME:"FirstName","Value":6785,"Lastname":"Charles","Address":"1103 pioneer St"}
  {NAME:"HouseName","Value":67783,"Lastname":"Stevenson","Address":"Abel St"}
  {NAME:"FoodName","Value":7473,"Lastname":"luther","Address":"Half Moon Bay"}
  </code></pre>
  
  <p>My table in MySQL is as follows:
  <strong>Name Value Lastname Address</strong></p>
  
  <p>I am using the following flow:</p>
  
  <p><strong>GetFile->SplitRecord->ConvertJsonToSQL ->PutSQL</strong></p>
  
  <p>I want under the <strong>NAME</strong> column all the first column attribute names of each row(FirstName, HouseName, FoodName) and under <strong>Value</strong> column its respective values to be entered.</p>
  
  <p>How can i achieve this use case in NiFi?
  What Regex I should use in the ReplaceText to achieve this. Anny help is appreciated. Thank You!</p>