# Data table with nested Fields

**URL:** <https://discuss.elastic.co/t/data-table-with-nested-fields/165026>\
**Category:** Kibana\
**Created:** [January 21, 2019, 10:22am UTC](https://discuss.elastic.co/t/data-table-with-nested-fields/165026 "2019-01-21T10:22:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![fadihaddad](https://avatars.discourse-cdn.com/v4/letter/f/4bbf92/32.png) [@fadihaddad](https://discuss.elastic.co/u/fadihaddad)\
**Post date:** [January 21, 2019, 10:22am UTC](https://discuss.elastic.co/t/data-table-with-nested-fields/165026/1 "2019-01-21T10:22:51Z")

</div>

I have this field in my documents

"DAList" : [  
{  
"DA\_Change" : 50195,  
"DA\_ID" : 8,  
"DA\_Before" : 325468,  
"DA\_After" : 275273,  
"DA\_ExpDate" : "2018-12-08T22:00:00.000Z"  
},  
{  
"DA\_Change" : 0,  
"DA\_ID" : 23,  
"DA\_Before" : 2660000,  
"DA\_After" : 2660000,  
"DA\_ExpDate" : "2018-12-08T22:00:00.000Z"  
}  
I want to view these data on the data table without mixing up values. Like I have number ID field in the same document and it mixes the nested fields data

 ![elastic%20table](https://us1.discourse-cdn.com/elastic/original/3X/c/8/c8faaa5e2665d7542ecddf70bf0a17bb998c6d07.png)  
I have 14 documents for testing and each DAList has 2 objects so I should have only 28 rows with no mixed up values

---

<div class="post-metadata">

**Author:** ![Magnus\_Kessler](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnus_kessler/32/42001_2.png) [@Magnus\_Kessler](https://discuss.elastic.co/u/Magnus_Kessler)\
**Post date:** [January 21, 2019, 5:56pm UTC](https://discuss.elastic.co/t/data-table-with-nested-fields/165026/2 "2019-01-21T17:56:57Z")

</div>

Kibana does not yet support [nested queries](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-nested-query.html). With a non-nested query you can get results where elements from the nested blocks are mixed. See the documentation for [nested datatypes](https://www.elastic.co/guide/en/elasticsearch/reference/current/nested.html) for more details.

---

<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:** [February 18, 2019, 5:57pm UTC](https://discuss.elastic.co/t/data-table-with-nested-fields/165026/3 "2019-02-18T17:57:03Z")

</div>

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