# I am unable to display columns in data table visualization

**URL:** <https://discuss.elastic.co/t/i-am-unable-to-display-columns-in-data-table-visualization/160164>\
**Category:** Kibana\
**Created:** [December 10, 2018, 12:20pm UTC](https://discuss.elastic.co/t/i-am-unable-to-display-columns-in-data-table-visualization/160164 "2018-12-10T12:20:30Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![lungelo\_zondo](https://avatars.discourse-cdn.com/v4/letter/l/82dd89/32.png) [@lungelo\_zondo](https://discuss.elastic.co/u/lungelo_zondo)\
**Post date:** [December 10, 2018, 12:20pm UTC](https://discuss.elastic.co/t/i-am-unable-to-display-columns-in-data-table-visualization/160164/1 "2018-12-10T12:20:30Z")

</div>

input {  
file {  
path =\> "C:/Users/zondol/data/example.csv.csv"  
start\_position =\> "beginning"  
sincedb\_path =\> "NUL"

```
}

```

}

filter {

```
    csv {

       separator => ";"

       columns => ["Jan","Feb","March","April"]
    }   

```

}

output {

```
elasticsearch{

 hosts => "http://localhost:9200"
 index => "months"
 document_type => "output_input_log"
}

stdout{codec => rubydebug}

```

}

 ![Visualize](https://us1.discourse-cdn.com/elastic/original/3X/e/3/e37bcde37d92357d17c0d7f380988aa7764cce55.png)

---

<div class="post-metadata">

**Author:** ![Joe\_Fleming](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_fleming/32/3561_2.png) [@Joe\_Fleming](https://discuss.elastic.co/u/Joe_Fleming)\
**Post date:** [December 10, 2018, 11:12pm UTC](https://discuss.elastic.co/t/i-am-unable-to-display-columns-in-data-table-visualization/160164/2 "2018-12-10T23:12:06Z")

</div>

Seems like it's not parsing your CSV input correctly. Your data looks like it's just one field named `message` and every line in the CSV is just dumped into that field.

What do you see if you look at the data in Elasticsearch directly, either via the REST api, or even in the Discover tab?

---

<div class="post-metadata">

**Author:** ![lungelo\_zondo](https://avatars.discourse-cdn.com/v4/letter/l/82dd89/32.png) [@lungelo\_zondo](https://discuss.elastic.co/u/lungelo_zondo)\
**Post date:** [December 11, 2018, 6:19am UTC](https://discuss.elastic.co/t/i-am-unable-to-display-columns-in-data-table-visualization/160164/3 "2018-12-11T06:19:21Z")

</div>

Hi Joe,

Thanks for replying.

Yeah i think you are correct but how can i sort this out, I am new to this.  
I want the column names to be months and each column field has a number allocated.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/0/4042758d03f67e81f23724d13dc52eaf257e45ac.png)

Please see this screenshot if you can help,

---

<div class="post-metadata">

**Author:** ![lungelo\_zondo](https://avatars.discourse-cdn.com/v4/letter/l/82dd89/32.png) [@lungelo\_zondo](https://discuss.elastic.co/u/lungelo_zondo)\
**Post date:** [December 12, 2018, 6:54am UTC](https://discuss.elastic.co/t/i-am-unable-to-display-columns-in-data-table-visualization/160164/4 "2018-12-12T06:54:57Z")

</div>

Joe ,

Can you please help on this if you can.

---

<div class="post-metadata">

**Author:** ![Joe\_Fleming](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_fleming/32/3561_2.png) [@Joe\_Fleming](https://discuss.elastic.co/u/Joe_Fleming)\
**Post date:** [December 14, 2018, 12:13am UTC](https://discuss.elastic.co/t/i-am-unable-to-display-columns-in-data-table-visualization/160164/5 "2018-12-14T00:13:22Z")

</div>

> I want the column names to be months and each column field has a number allocated.

I think this might be a misunderstanding of how the data model in Elasticsearch works here. Since it's just a document store, you end up structuring your data differently than if this were a relational thing (like SQL, for example). Every column you see in that table maps to a field in your documents, so you'd end up indexing a single document with fields for each month, and a value for each one. But that seems wrong... what you _probably_ want to do it store information with a "month" field and some other field for the value, kind of like this:

```auto
{
  "month": "January",
  "value": 1
}

```

Then you'd let Elasticsearch do its thing and aggregate that into the data you want to look at.

Can you give me some sample of the original CSV data (even if you have to abstract it, I just want to understand the structure and what it means) and tell me what you're trying to visualize here? That would help me explain how you'd index the data and look at it in Kibana.

---

<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:** [January 11, 2019, 12:13am UTC](https://discuss.elastic.co/t/i-am-unable-to-display-columns-in-data-table-visualization/160164/6 "2019-01-11T00:13:22Z")

</div>

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