How to add lookup fields to kibana visualization?

Elastic Stack Kibana
1

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.

2

Hi I'm pretty sure this is not possible in Lens right now.
If your lookup table is not too big and is static you can create such kind of lookup using a scripted field.
I'm checking the Lens team if this is under their radar in the near future

3

Is this possible in visualize or something else in kibana? We've been migrating from mongo and really need lookup fields to rebuild the dashboard

4

At the moment the only things you can do are:

  • do that lookup upfront, at index time
  • use a static-lookup field in the index pattern
    There are multiple discussion around about adding or not this feature to Elasticsearch but there is no such solution at the moment
5

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.