title: Kibana: joining two documents in table visualization
body: <p>I have a data table visualization displaying fields from documents that have an email address and an id:</p>
  
  <pre><code>timestamp |         email       |  field_id
   Feb 5th       jdoe@gmail.com       xyz123
  </code></pre>
  
  <p>These fields belong to the same elastic document. However, I have other documents with extra information pertaining to this unique id, and can display these as their own table:</p>
  
  <pre><code>timestamp |  field_id   |    key1   |   key2   |  key3
    Feb 6th     xyz123         val1       val2      val3
  </code></pre>
  
  <p>You can see the row in the first table and the one on the second table have the field_id in common. What I'd like to know is whether it is possible to display a merged row with Kibana and/or an elastic query:</p>
  
  <pre><code> field_id   |     email      |    key1   |   key2   |  key3
     xyz123     jdoe@gmail.com      val1       val2      val3
  </code></pre>
  
  <p>This would be somewhat equivalent to a join for a relation database in SQL. If this is not possible in Kibana, maybe there is a way to achieve this indirectly with a query using the json input with elastic and perform a kind of application-side join?</p>