# How Can I make my csv fields available on the Filter drop down in Kibana when discovering the data via the index?

**URL:** <https://discuss.elastic.co/t/how-can-i-make-my-csv-fields-available-on-the-filter-drop-down-in-kibana-when-discovering-the-data-via-the-index/107643>\
**Category:** Logstash\
**Created:** [November 14, 2017, 10:35pm UTC](https://discuss.elastic.co/t/how-can-i-make-my-csv-fields-available-on-the-filter-drop-down-in-kibana-when-discovering-the-data-via-the-index/107643 "2017-11-14T22:35:19Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![sconrod](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sconrod/32/23910_2.png) [@sconrod](https://discuss.elastic.co/u/sconrod)\
**Post date:** [November 14, 2017, 10:35pm UTC](https://discuss.elastic.co/t/how-can-i-make-my-csv-fields-available-on-the-filter-drop-down-in-kibana-when-discovering-the-data-via-the-index/107643/1 "2017-11-14T22:35:19Z")

</div>

Below have pasted the .conf file and the mappings output:

root@ubuntu-16:/etc/logstash/conf.d# cat bzip4-v4.conf  
input {  
file {  
path =\> "/opt/sample-data/csv/bzip4/\*.csv"  
start\_position =\> "beginning"  
sincedb\_path =\> "/dev/null"  
}  
}  
filter {  
csv {  
convert =\> {  
"column1" =\> "boolean"  
"column2" =\> "integer"  
}  
}  
}  
output {  
elasticsearch { hosts =\> ["localhost:9200"]

# embedded =\> "true"

# action =\> "index"

index =\> "bzip4-v4"

# document\_type =\> "csv"

# document\_id =\> "%{property\_id}"

user =\> "logstash\_internal"  
password =\> "xxxxxxxx"  
hosts =\> ["10.0.2.15:9200"]  
}  
stdout {codec =\> rubydebug}  
}

# ================================================================== The index is created but when I Discover the data in Kibana, and select filter, I cannot see my two fields 'column1' and 'column2' as searchable fields in the filter drop down. Here is the mapping:

root@ubuntu-16:/etc/logstash/conf.d# curl -u elastic:changeme -XGET 'localhost:9200/bzip4-v4/\_mapping/?pretty'  
{  
"bzip4-v4" : {  
"mappings" : {  
"logs" : {  
"properties" : {  
"@timestamp" : {  
"type" : "date"  
},  
"@version" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"column1" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"column2" : {  
"type" : "long"  
},  
"host" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"message" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"path" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
}  
}  
}  
}  
}  
}

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [November 15, 2017, 7:01am UTC](https://discuss.elastic.co/t/how-can-i-make-my-csv-fields-available-on-the-filter-drop-down-in-kibana-when-discovering-the-data-via-the-index/107643/2 "2017-11-15T07:01:03Z")

</div>

Did you refresh the fields in Kibana?

---

<div class="post-metadata">

**Author:** ![sconrod](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sconrod/32/23910_2.png) [@sconrod](https://discuss.elastic.co/u/sconrod)\
**Post date:** [November 15, 2017, 5:26pm UTC](https://discuss.elastic.co/t/how-can-i-make-my-csv-fields-available-on-the-filter-drop-down-in-kibana-when-discovering-the-data-via-the-index/107643/3 "2017-11-15T17:26:44Z")

</div>

Yes, and when I select the filter drop down box, all I see is \_ID

Are the mappings and conf file set up correctly?

---

<div class="post-metadata">

**Author:** ![sconrod](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sconrod/32/23910_2.png) [@sconrod](https://discuss.elastic.co/u/sconrod)\
**Post date:** [November 15, 2017, 5:27pm UTC](https://discuss.elastic.co/t/how-can-i-make-my-csv-fields-available-on-the-filter-drop-down-in-kibana-when-discovering-the-data-via-the-index/107643/4 "2017-11-15T17:27:53Z")

</div>

It must be something with either that csv filter plugin OR the configuration because I am also using the Jenkins-logstash plugin without any issues, and all fields are showing from the filter drop down

---

<div class="post-metadata">

**Author:** ![sconrod](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sconrod/32/23910_2.png) [@sconrod](https://discuss.elastic.co/u/sconrod)\
**Post date:** [December 1, 2017, 8:11pm UTC](https://discuss.elastic.co/t/how-can-i-make-my-csv-fields-available-on-the-filter-drop-down-in-kibana-when-discovering-the-data-via-the-index/107643/5 "2017-12-01T20:11:19Z")

</div>

Since I upgraded to 6.0 this is no longer an issue.

---

<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:** [December 29, 2017, 8:11pm UTC](https://discuss.elastic.co/t/how-can-i-make-my-csv-fields-available-on-the-filter-drop-down-in-kibana-when-discovering-the-data-via-the-index/107643/6 "2017-12-29T20:11:28Z")

</div>

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