Map string value of an ID to a custom String using JSON input

[officer_snickers]

I'm totally new to kibana.

I have the current problem, I created a visualisation chart which is splitting rows based on the UUID. In this Index, I unfortunately don't have the related organisation name to the UUID.

My question now is can I map the UUIDs to a specific String value using "advanced JSON input"? So i see the organisation names instead of the UUIDs.

Eg.
if organisation_uuid == "1001" {
organisation_uuid = "Organisation 1"
} else if organisation_uuid == "1002" {
organisation_uuid = "Organisation 2"
} else if ...

Thank you in advance for helping a newbie

[thomasneirynck]

hi @officer_snickers

this kind of transformation of one value to another (e.g. 1001 -> Organization 1) is easiest to do with a scripted-field: https://www.elastic.co/guide/en/kibana/current/scripted-fields.html Basically, you would create a new scripted field that uses a little script to generate the value.

It's a feature of a Kibana index pattern. You would write a script in the painless-language that does this transformation. More details here https://www.elastic.co/guide/en/elasticsearch/painless/7.10/painless-walkthrough.html