I have two files: us_data_flights and us_states_geo_coordinates.
a) In the file us_data_flights there are data about flights in 2015 with information about departure/arrival state, air_time, delay etc...
b) In the file us states_geo_coordinates there are geo-coordinates for every state.
I would like to generate a Map with delay metrics with kibana.
How can I make a join between field 'state' of file a) and field 'state" of file b) in order to extract coordinates to plot on map?
Thank you very much at all!