Doing visualization from multiple documents

[Harsh_Verma]

I have an index with documents having structure like

   {
      department:department_value, 
      employee_id:id_value
    }  
    and some more documents with structure like 
    {
      age:42, 
      tags:[
                {key:employee_id, value:id_value}
              ]
    }

if I wanted to combine the data from these two documents in my visualization based on employee_id, is there any way to do that in Kibana, or can I write a Elasticsearch query in Kibana for something like this? Or is there any visualization tool apart from Kibana for Elasticsearch that can support this?

[warkolm (Mark Walkom)]

That's a join which Kibana or Elasticsearch cannot handle.
You would be best off normalising/joining things before sending them for indexing.