Can we use case statement while making scripted field in kibana OR we just have to use if else
Scripted fields in Kibana use the Painless language which does not feature a switch statement: https://www.elastic.co/guide/en/elasticsearch/painless/current/painless-statements.html