# How to show multi field value in discover table

**URL:** <https://discuss.elastic.co/t/how-to-show-multi-field-value-in-discover-table/205863>\
**Category:** Kibana\
**Created:** [October 30, 2019, 12:50pm UTC](https://discuss.elastic.co/t/how-to-show-multi-field-value-in-discover-table/205863 "2019-10-30T12:50:48Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![prakhara](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prakhara/32/45904_2.png) [@prakhara](https://discuss.elastic.co/u/prakhara)\
**Post date:** [October 30, 2019, 12:50pm UTC](https://discuss.elastic.co/t/how-to-show-multi-field-value-in-discover-table/205863/1 "2019-10-30T12:50:49Z")

</div>

I have created a field as multi field in elastic mapping, originalfield as text and originalfield.keyword as keyword for aggregation but while showing the data in discover table only I get the value in originalfield and not in originalfield.keyword . I need to get the .keyword field as i want to perform sort and filter which is not possible on original field

---

<div class="post-metadata">

**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\
**Post date:** [November 1, 2019, 5:49pm UTC](https://discuss.elastic.co/t/how-to-show-multi-field-value-in-discover-table/205863/2 "2019-11-01T17:49:25Z")

</div>

Since the `keyword` fields aren't part of the original source document they don't show up in the left sidebar of discover automatically. You can make them appear by unchecking the "Hide missing fields" option. You'll probably want to put the text and keyword versions side by side in the table, because the keyword column will not show values (again, because there are no values for this field in the original source document) but you _will_ be able to sort on it.

---

<div class="post-metadata">

**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\
**Post date:** [November 1, 2019, 5:55pm UTC](https://discuss.elastic.co/t/how-to-show-multi-field-value-in-discover-table/205863/3 "2019-11-01T17:55:35Z")

</div>

`Hide missing fields` option is visible after clicking `Filter by type`

 ![15%20AM](https://us1.discourse-cdn.com/elastic/original/3X/7/0/703d7c7a9df4baf0d607911bc4371c8398a37524.png)

---

<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:** [November 29, 2019, 5:55pm UTC](https://discuss.elastic.co/t/how-to-show-multi-field-value-in-discover-table/205863/4 "2019-11-29T17:55:41Z")

</div>

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