# Create a new collumn based on an existing one in Managament index Patterns
**URL:** https://discuss.elastic.co/t/create-a-new-collumn-based-on-an-existing-one-in-managament-index-patterns/145375
**Category:** Kibana
**Created:** [August 21, 2018, 11:18am UTC](https://discuss.elastic.co/t/create-a-new-collumn-based-on-an-existing-one-in-managament-index-patterns/145375 "2018-08-21T11:18:38Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Amon](https://discuss.elastic.co/u/Amon)
#### Post date: [August 21, 2018, 11:18am UTC](https://discuss.elastic.co/t/create-a-new-collumn-based-on-an-existing-one-in-managament-index-patterns/145375/1 "2018-08-21T11:18:38Z")
Dear,
I have in my data a column which contains strings, now I want to create a new collumn which give a value to this strings "a certain type=0, another one =-1 and the last type has a value equal to 1". Is this possible to do it in this way and yes where can I find it?
With kind regards Amon De Keyser
---
### Author:  [@lukas](https://discuss.elastic.co/u/lukas)
#### Post date: [August 21, 2018, 8:45pm UTC](https://discuss.elastic.co/t/create-a-new-collumn-based-on-an-existing-one-in-managament-index-patterns/145375/2 "2018-08-21T20:45:57Z")
This sort of thing should really be done at index time, not after the fact. But you can create a scripted field. More information here: [https://www.elastic.co/guide/en/kibana/current/scripted-fields.html](https://www.elastic.co/guide/en/kibana/current/scripted-fields.html)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 18, 2018, 8:46pm UTC](https://discuss.elastic.co/t/create-a-new-collumn-based-on-an-existing-one-in-managament-index-patterns/145375/3 "2018-09-18T20:46:02Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.