Creating a new column from existing columns

Elastic Stack Elasticsearch
1

Dear Elasticsearch community,

I was wondering how I can create a DateTime column from 5 columns (forecasted_year,month,day,hour,minute) as it is shown in the image (after creating a new index).

I am not sure if this should be done when creating the mapping of the index

Thank you!

recorte

2

This should be done at the ingest time
Use for example an ingest pipeline to compose and convert a datetime field