title: Elastic search concatenation of fields
body: <p>I am new to elastic search and wanted to solve an use case with below problem </p>
  
  <p>I have some documents as below format</p>
  
  <pre><code>{
   "member_id":"number"
   "e_id":"number",
   "c_id":"number",
   "salary":"float"
  }
  </code></pre>
  
  <p>In my Java application, I will get a String input and need to find the matching document's <b>member_id</b>. The algorithm to find the document is as below </p>
  
  <p>STEP 1: <I> Take input string as "keyInput".</I><BR>
  STEP 2:<I> Concat "e_id","c_id" and ceil("salary")  as "concatedData" </I><BR>
  STEP 3: <I> if "concatedData" equals to "keyInput" THEN return the "member_id" of the matching document.</I></p>
  
  <p>STEP 2 need to be performed in Elasticsearch.</p>
  
  <p>Can anyone help to figure out if this kind of actions can be performed on ES or not, if Yes then how?</p>
  
  <p>Thanks in Advance.</p>