# In data table visualization i have 5 columns but in one column, only one data is coming

**URL:** <https://discuss.elastic.co/t/in-data-table-visualization-i-have-5-columns-but-in-one-column-only-one-data-is-coming/338421>\
**Category:** Logstash\
**Created:** [July 14, 2023, 2:29pm UTC](https://discuss.elastic.co/t/in-data-table-visualization-i-have-5-columns-but-in-one-column-only-one-data-is-coming/338421 "2023-07-14T14:29:58Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Malikmamta](https://avatars.discourse-cdn.com/v4/letter/m/f07891/32.png) [@Malikmamta](https://discuss.elastic.co/u/Malikmamta)\
**Post date:** [July 14, 2023, 2:29pm UTC](https://discuss.elastic.co/t/in-data-table-visualization-i-have-5-columns-but-in-one-column-only-one-data-is-coming/338421/1 "2023-07-14T14:29:58Z")

</div>

in data table visualization, I have 5 columns but in one column, only one row is missing instead of 10 rows. in that column multiline are there. In discover, i can see complete data but for that one column, only single row is coming instead of 10 rows. rest all column is coming fine.

---

<div class="post-metadata">

**Author:** ![Priscilla\_Parodi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/priscilla_parodi/32/43047_2.png) [@Priscilla\_Parodi](https://discuss.elastic.co/u/Priscilla_Parodi)\
**Post date:** [July 14, 2023, 7:48pm UTC](https://discuss.elastic.co/t/in-data-table-visualization-i-have-5-columns-but-in-one-column-only-one-data-is-coming/338421/2 "2023-07-14T19:48:36Z")

</div>

Hello @Malikmamta,

Welcome to the community!

Are you talking about a data table visualization on a specific dashboard in Kibana? Which version of Elastic are you using? What is the field data type? Which aggregation are you utilizing? Do you have any filters enabled on that dashboard?

Thank you!

---

<div class="post-metadata">

**Author:** ![Malikmamta](https://avatars.discourse-cdn.com/v4/letter/m/f07891/32.png) [@Malikmamta](https://discuss.elastic.co/u/Malikmamta)\
**Post date:** [July 17, 2023, 12:14pm UTC](https://discuss.elastic.co/t/in-data-table-visualization-i-have-5-columns-but-in-one-column-only-one-data-is-coming/338421/3 "2023-07-17T12:14:21Z")

</div>

Version: 8.6.1

Yes data table visualization.  
field data type is keyword.

I am creating visualization for my data. my data contains 5 columns. out of them one has more number of character if i am adding that column in split row only one data is coming instead of 100.  
if i dont use that specific column rest all 100 rows are coming.

Sample data:  
Sno,name,floor,company,details  
1,xyz,ist,company, [url] rest api [company] some\_company [des] git commit[api\_name]any restapi[local] \*\*\*\*url:https:abc.com \*\*\*\*

so if i am adding these data in visualize, other than details column everything is coming but only one detail row is coming. but rest 99 data it is showing missing.

In discover i can see complete data

---

<div class="post-metadata">

**Author:** ![Priscilla\_Parodi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/priscilla_parodi/32/43047_2.png) [@Priscilla\_Parodi](https://discuss.elastic.co/u/Priscilla_Parodi)\
**Post date:** [July 17, 2023, 7:14pm UTC](https://discuss.elastic.co/t/in-data-table-visualization-i-have-5-columns-but-in-one-column-only-one-data-is-coming/338421/4 "2023-07-17T19:14:30Z")

</div>

Thanks for the additional context. What metric are you using for the table? Is there any filter enabled? A screenshot of the table visualization (with and without the 'details') and the configuration of metrics and buckets would be helpful. Feel free to blur sensitive data.

---

<div class="post-metadata">

**Author:** ![Malikmamta](https://avatars.discourse-cdn.com/v4/letter/m/f07891/32.png) [@Malikmamta](https://discuss.elastic.co/u/Malikmamta)\
**Post date:** [July 18, 2023, 10:11am UTC](https://discuss.elastic.co/t/in-data-table-visualization-i-have-5-columns-but-in-one-column-only-one-data-is-coming/338421/5 "2023-07-18T10:11:35Z")

</div>

I am using data table visualization. Data i have uploaded using logstash filter.  
One of the column of my csv has multilple lines.

For example:

```auto
[url] rest api [company] some_company [des] git commit[api_name]any restapi[local] ****url:https:abc.com****

```

This is one column that i can see in data table. This is having 256 character. other than that in same column there are rows which has more than 256 character. I have modified  
ignore\_above": 512000

```auto
mapping": {
          "keyword": {
            "type": "keyword",
            "ignore_above": 512000
          }
        }

```

still rest rows are not coming in data table.

---

<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 15, 2023, 10:11am UTC](https://discuss.elastic.co/t/in-data-table-visualization-i-have-5-columns-but-in-one-column-only-one-data-is-coming/338421/6 "2023-08-15T10:11:56Z")

</div>

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