Join information between 2 Data inputs

Elastic Stack Logstash
1

Hi experts,
i would like to know if it's possible to join two input file in order to create a new file and send the result to elasticsearch ?

Ex: I've input data from SQL and another input data from JSON file. I would like to make a new field base on one field from the SQL input and from the JSON file.

Best Regards,
PM

2

You might be able to use a translate filter to do that.