Kibana: joining two documents in table visualization
<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>