I would like to create a visualisation on Kibana that aggregate documents by a specific field. However the existing field (lets call it interaction_name) is built as follow :
Name_Interaction | Number
I want to create a new field that contains only the Name_Interaction (delete "| Number") to allow the aggregation by this new field.
How can I do that, without creating the field in my database? Is there a function regexp that I can implement in the Console and update the index ?
Thanks in advance,