# .keyword columns empty in "Discover"

**URL:** <https://discuss.elastic.co/t/keyword-columns-empty-in-discover/108531>\
**Category:** Kibana\
**Created:** [November 21, 2017, 8:03am UTC](https://discuss.elastic.co/t/keyword-columns-empty-in-discover/108531 "2017-11-21T08:03:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sspilleman](https://avatars.discourse-cdn.com/v4/letter/s/9dc877/32.png) [@sspilleman](https://discuss.elastic.co/u/sspilleman)\
**Post date:** [November 21, 2017, 8:03am UTC](https://discuss.elastic.co/t/keyword-columns-empty-in-discover/108531/1 "2017-11-21T08:03:26Z")

</div>

Hi,

I'm indexing quite a few text mappings to alse have a .keyword couterpart with type keyword.

Like:

```auto
"country": {
            "type": "text",
            "fields": {
              "keyword": {
                "type": "keyword",
                "ignore_above": 256
              }
            }
          }

```

When I add the country.keyword as one of the columns, the value is empty. Hence I have to add both "country" AND "country.keyword" columns if want to see the value and have the option to sort on them by clicking on the sort arrow in the column title.... This is rather annoying as it consumes quite some screen estate and its cumbersome to add the country.keyword one as I have to first "show missing fields" before I can select it....

Am I missing something / not doing it right?

Regards,

Sander

---

<div class="post-metadata">

**Author:** ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)\
**Post date:** [November 21, 2017, 8:02pm UTC](https://discuss.elastic.co/t/keyword-columns-empty-in-discover/108531/2 "2017-11-21T20:02:36Z")

</div>

You can make your `country` field mapped as `keyword`, and have a `country.text` field mapped as `text`:

```auto
        "country": {
          "type": "keyword",
          "ignore_above": 256,
          "fields": {
            "text": {
              "type": "text"
            }
          }
        }

```

---

<div class="post-metadata">

**Author:** ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)\
**Post date:** [November 21, 2017, 8:03pm UTC](https://discuss.elastic.co/t/keyword-columns-empty-in-discover/108531/3 "2017-11-21T20:03:22Z")

</div>

Depending on your use case, you might not really need that `text` field though 😃

---

<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:** [December 19, 2017, 8:03pm UTC](https://discuss.elastic.co/t/keyword-columns-empty-in-discover/108531/4 "2017-12-19T20:03:27Z")

</div>

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