# Change null value from database for one field using logstash and insert into Elasticsearch

**URL:** https://discuss.elastic.co/t/change-null-value-from-database-for-one-field-using-logstash-and-insert-into-elasticsearch/97552
**Category:** Logstash
**Created:** [August 18, 2017, 9:48am UTC](https://discuss.elastic.co/t/change-null-value-from-database-for-one-field-using-logstash-and-insert-into-elasticsearch/97552 "2017-08-18T09:48:29Z")
**Posts on this page:** 1
**Showing post:** 8

<div class="post-metadata">

### Author: ![malhotras](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@malhotras](https://discuss.elastic.co/u/malhotras)
#### Post date: [August 21, 2017, 1:09pm UTC](https://discuss.elastic.co/t/change-null-value-from-database-for-one-field-using-logstash-and-insert-into-elasticsearch/97552/8 "2017-08-21T13:09:32Z")

</div>

Here is the link to my other question:

> [@Translate filter to match the custom values](https://discuss.elastic.co/t/translate-filter-to-match-the-custom-values/97773):
>
> I would like to use the translate filter dictionary plugin to define my custom values. It seems simple to use it, though is it possible to have something like this translate { dictionary =\> ["2", "f", "3", "16e", "9", "bio", "11", "wrm", "anything other than digits mentioned already", "everything else"] field =\> "format\_id" destination =\> "mformat" } So, the question is, is it possible to do something like this, where we can define everything else field?? Or, a better way …

---

_[View the full topic](https://discuss.elastic.co/t/change-null-value-from-database-for-one-field-using-logstash-and-insert-into-elasticsearch/97552)._