Merge and transform more than one csv or json files to elasticsearch from logstash or ingest node pipeline (beginner)

[namali (mali)]

I wanted to know how to merge and transform more than one csv or json files to elasticsearch from logstash or ingest node pipeline.

*hotel.csv
hotelcode
hotelname
starcode

*star.csv
starcode
starrating

after merge index should have
hotelcode
hotelname
starcode
starrating

[Badger]

Use a translate filter.

[namali (mali)]

Thanks, I will try and see

[namali (mali)]

this works from translate. Thx

[namali (mali)]

this works when key field is in first column in dictionary_path data file. I want to know how to merge files when key field is not in first column

translate {
destination => "[@metadata][lookup1]"
dictionary_path => "/home/namalie/elk/test/starrating.csv"
field => "starcode" }
dissect { mapping => { "[@metadata][lookup1]" => "%{starrating}" } }