title: Passing parameter from different source into insert statement using Nifi
body: <p>I'm still new in NiFi. What I want to achieve is to pass a parameter from a different source.</p>
  <p>Scenario:</p>
  <p>I have 2 datasource which is Json data and record id (from oracle function). I declared record id using extract text as &quot;${recid}&quot; and json string default is &quot;$1&quot; .</p>
  <p>How to insert into table using sql statement  insert into table1 (json,recid) value ('$1','${recid}')</p>
  <p>After I run the processor. I'm not able to get both attribute into one insert statement.</p>
  <p>Please help.</p>
  <p><a href="https://i.stack.imgur.com/SX4NY.png" rel="nofollow noreferrer">Nifi flowfile</a>
  <a href="https://i.stack.imgur.com/njh8X.png" rel="nofollow noreferrer">Flowfile after mergecontent</a></p>