# How to add lookup fields to kibana visualization?

**URL:** <https://discuss.elastic.co/t/how-to-add-lookup-fields-to-kibana-visualization/260662>\
**Category:** Kibana\
**Created:** [January 11, 2021, 2:56am UTC](https://discuss.elastic.co/t/how-to-add-lookup-fields-to-kibana-visualization/260662 "2021-01-11T02:56:33Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rithwik\_Pat](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rithwik_pat/32/81999_2.png) [@Rithwik\_Pat](https://discuss.elastic.co/u/Rithwik_Pat)\
**Post date:** [January 11, 2021, 2:56am UTC](https://discuss.elastic.co/t/how-to-add-lookup-fields-to-kibana-visualization/260662/1 "2021-01-11T02:56:33Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![markov00](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/markov00/32/33316_2.png) [@markov00](https://discuss.elastic.co/u/markov00)\
**Post date:** [January 11, 2021, 11:50am UTC](https://discuss.elastic.co/t/how-to-add-lookup-fields-to-kibana-visualization/260662/2 "2021-01-11T11:50:59Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Rithwik\_Pat](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rithwik_pat/32/81999_2.png) [@Rithwik\_Pat](https://discuss.elastic.co/u/Rithwik_Pat)\
**Post date:** [January 11, 2021, 12:02pm UTC](https://discuss.elastic.co/t/how-to-add-lookup-fields-to-kibana-visualization/260662/3 "2021-01-11T12:02:18Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![markov00](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/markov00/32/33316_2.png) [@markov00](https://discuss.elastic.co/u/markov00)\
**Post date:** [January 11, 2021, 12:17pm UTC](https://discuss.elastic.co/t/how-to-add-lookup-fields-to-kibana-visualization/260662/4 "2021-01-11T12:17:02Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [February 8, 2021, 12:17pm UTC](https://discuss.elastic.co/t/how-to-add-lookup-fields-to-kibana-visualization/260662/5 "2021-02-08T12:17:06Z")

</div>

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