How to derive final data from subset as an input?

[amolagnihotri]

From a set of data (say, Parent Set), we want to extract a subset of data (say, ColumnSet) which will be a column with multiple records and then again get all the data using that column(Column Set).

[spalger (Spencer Alger)]

Can you provide some more information about the data and expected result? I'm not following your example. Please include some JSON that represents what you have stored in elasticsearch and perhaps an example of what from that data you want to visualize.

If you don't have data in elasticsearch yet, please just provide more information about the data you do have and the expected result

[amolagnihotri]

As an example I have two sets of an employee data

1. 
   {
   "query": {
   "match": {
   "_type": {
   "query": "employee_data",
   "type": "phrase"
   }
   }
   }
   }
2. 
   {
   "query": {
   "match": {
   "_type": {
   "query": "insurance_policy_details",
   "type": "phrase"
   }
   }
   }
   }

To create a visualization I need a data which has some columns of "employee_data" and some of "insurance_policy_details". Data set I require within Discover tab is

Please Note:

1. I need data only for the employees with "document Status: Verified"
2. I need all the insurance policies associated with every individual.

Thanks