Say I am using lens to find all product ids in an index with a certain criteria and display in a table. Then I want to lookup the product id in another index to get the product name. So finally the result is a table that has a list of all the product names instead of just ids.
In mongo charts this is called lookup fields but I can't find the equivalent in kibana charts.