# How to convert a field to uppercase in Kibana and do a lookup

**URL:** <https://discuss.elastic.co/t/how-to-convert-a-field-to-uppercase-in-kibana-and-do-a-lookup/192472>\
**Category:** Kibana\
**Created:** [July 26, 2019, 3:29pm UTC](https://discuss.elastic.co/t/how-to-convert-a-field-to-uppercase-in-kibana-and-do-a-lookup/192472 "2019-07-26T15:29:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nagendra\_Dattatreya](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nagendra_dattatreya/32/51023_2.png) [@Nagendra\_Dattatreya](https://discuss.elastic.co/u/Nagendra_Dattatreya)\
**Post date:** [July 26, 2019, 3:29pm UTC](https://discuss.elastic.co/t/how-to-convert-a-field-to-uppercase-in-kibana-and-do-a-lookup/192472/1 "2019-07-26T15:29:42Z")

</div>

I have a field that has both uppercase and lowercase, I want to transform all values to uppercase and also want to transform the code to a description. I know you can do either of this using format, can we do both on the same filed?

for e.g.

a field has 'abc' and 'ABC' want to convert 'abc' to ABC and then give a description

---

<div class="post-metadata">

**Author:** ![cjcenizal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cjcenizal/32/11216_2.png) [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)\
**Post date:** [July 26, 2019, 10:25pm UTC](https://discuss.elastic.co/t/how-to-convert-a-field-to-uppercase-in-kibana-and-do-a-lookup/192472/2 "2019-07-26T22:25:10Z")

</div>

Hi there! Thanks for asking your question on the forum. Please see this post which will answer your question: [How to convert one field in uppercase in kibana](https://discuss.elastic.co/t/how-to-convert-one-field-in-uppercase-in-kibana/101794/2).

Could you explain what you mean by giving a description? What's the description based upon?

---

<div class="post-metadata">

**Author:** ![Nagendra\_Dattatreya](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nagendra_dattatreya/32/51023_2.png) [@Nagendra\_Dattatreya](https://discuss.elastic.co/u/Nagendra_Dattatreya)\
**Post date:** [July 26, 2019, 10:40pm UTC](https://discuss.elastic.co/t/how-to-convert-a-field-to-uppercase-in-kibana-and-do-a-lookup/192472/3 "2019-07-26T22:40:57Z")

</div>

Thanks, Basically we are sending Code (some codes are uppercase and some are lowercase) to ES and wanted to show description in Kibana. I created a scripted field and used doc['field'].value.toUpperCase() and then used a lookup to show the description.

---

<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:** [August 23, 2019, 10:40pm UTC](https://discuss.elastic.co/t/how-to-convert-a-field-to-uppercase-in-kibana-and-do-a-lookup/192472/4 "2019-08-23T22:40:58Z")

</div>

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