# Table Visualisation - replace field \[error code\] value by some text

**URL:** <https://discuss.elastic.co/t/table-visualisation-replace-field-error-code-value-by-some-text/206981>\
**Category:** Kibana\
**Created:** [November 7, 2019, 3:38pm UTC](https://discuss.elastic.co/t/table-visualisation-replace-field-error-code-value-by-some-text/206981 "2019-11-07T15:38:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![zebu14](https://avatars.discourse-cdn.com/v4/letter/z/aca169/32.png) [@zebu14](https://discuss.elastic.co/u/zebu14)\
**Post date:** [November 7, 2019, 3:38pm UTC](https://discuss.elastic.co/t/table-visualisation-replace-field-error-code-value-by-some-text/206981/1 "2019-11-07T15:38:06Z")

</div>

Hello,

I am trying to do a Table visualisation to show the different "error codes" found in the daily log and their respective count.

The codes are int numbers : 0= OK, 166= Creation Failure, ...

Is it possible to force Kibana to show anything else than the real "value" of the code.  
An "eval" function, or something in "JSON input"

I have this :

 ![firefox_2019-11-07_16-32-04](https://us1.discourse-cdn.com/elastic/original/3X/7/0/7006393f1577764edb7054143aad039f669a326e.png)

But I want an error code description, instead of the number of error code.

Thank you

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [November 11, 2019, 2:08pm UTC](https://discuss.elastic.co/t/table-visualisation-replace-field-error-code-value-by-some-text/206981/2 "2019-11-11T14:08:13Z")

</div>

Hello,

You can use scripted fields in Kibana to map the error codes to a text value.  
Here is how you use scripted fields - [https://www.elastic.co/guide/en/kibana/current/scripted-fields.html](https://www.elastic.co/guide/en/kibana/current/scripted-fields.html)

The operation is a little bit expensive resource vice. So you will need to check and see if it works for you.

Thanks,  
Bhavya

---

<div class="post-metadata">

**Author:** ![zebu14](https://avatars.discourse-cdn.com/v4/letter/z/aca169/32.png) [@zebu14](https://discuss.elastic.co/u/zebu14)\
**Post date:** [November 12, 2019, 9:28am UTC](https://discuss.elastic.co/t/table-visualisation-replace-field-error-code-value-by-some-text/206981/3 "2019-11-12T09:28:24Z")

</div>

Thanks, I will try that and let you know

Xavier

---

<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 10, 2019, 9:28am UTC](https://discuss.elastic.co/t/table-visualisation-replace-field-error-code-value-by-some-text/206981/4 "2019-12-10T09:28:35Z")

</div>

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