# Value in Table and JSON are different

**URL:** <https://discuss.elastic.co/t/value-in-table-and-json-are-different/239135>\
**Category:** Kibana\
**Created:** [June 29, 2020, 3:03pm UTC](https://discuss.elastic.co/t/value-in-table-and-json-are-different/239135 "2020-06-29T15:03:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ranju](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ranju/32/84299_2.png) [@ranju](https://discuss.elastic.co/u/ranju)\
**Post date:** [June 29, 2020, 3:03pm UTC](https://discuss.elastic.co/t/value-in-table-and-json-are-different/239135/1 "2020-06-29T15:03:47Z")

</div>

Facing This Issue

> [@Numbers in Table and JSON are different](https://discuss.elastic.co/t/numbers-in-table-and-json-are-different/218362):
>
> I noticed strange thing in logs: the number-value of marker in table-view differs from the corresponding value of field in JSON. What is this? [image] [image]

in JSON the value

"test": {  
"test\_id": "1111111111111180522"  
},

in Kibana table showing as: 1111111111111180526

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [June 29, 2020, 3:14pm UTC](https://discuss.elastic.co/t/value-in-table-and-json-are-different/239135/2 "2020-06-29T15:14:03Z")

</div>

Did you read the answer I put in that post? It's the same problem for you. Javascript is simply unable to handle numbers that large - you have to treat them as a string (which also includes using the string formatter for them)

---

<div class="post-metadata">

**Author:** ![ranju](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ranju/32/84299_2.png) [@ranju](https://discuss.elastic.co/u/ranju)\
**Post date:** [June 29, 2020, 4:30pm UTC](https://discuss.elastic.co/t/value-in-table-and-json-are-different/239135/3 "2020-06-29T16:30:19Z")

</div>

@flash1293 yes agree with your Ans  
but I need it as long currently there are so many data in data type long **test\_id**

if we change to String. it will affect old data, right?

---

<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:** [July 27, 2020, 4:30pm UTC](https://discuss.elastic.co/t/value-in-table-and-json-are-different/239135/4 "2020-07-27T16:30:25Z")

</div>

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