# JSON Input Help w/ Kibana data table

**URL:** <https://discuss.elastic.co/t/json-input-help-w-kibana-data-table/26025>\
**Category:** Kibana\
**Created:** [July 21, 2015, 9:13pm UTC](https://discuss.elastic.co/t/json-input-help-w-kibana-data-table/26025 "2015-07-21T21:13:16Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\
**Post date:** [January 18, 2017, 11:30pm UTC](https://discuss.elastic.co/t/json-input-help-w-kibana-data-table/26025/8 "2017-01-18T23:30:59Z")

</div>

I know this is quite old, and we've all grown up and had kids now, 😉 but I posted a solution last December that might be applicable here (WARNING it might not perform well on very large sets of data).

Basically you create a new scripted field for each of your "statuses" and set them to 1 if they match the name of that status. See;

> [@Datatable config case help](https://discuss.elastic.co/t/datatable-config-case-help/68123/2):
>
> Hi Joodies, I'm guessing a and b are values of type and new, wip, and done are values of status So you're trying to create a data table with terms across the top and down the side. Unfortunately Kibana can't do that (yet). But I came up with a hack of a work-around. I create test data using the Dev Tools console like this; PUT index1/type1/1 { "type": "a", "status": "new" } PUT index1/type1/2 { "type": "a", "status": "wip" } PUT index1/type1/3 { "type": "b", "status": "new" …

---

_[View the full topic](https://discuss.elastic.co/t/json-input-help-w-kibana-data-table/26025)._