I have 2 CVS files which contains one similar column header say "faculty_id",
For the rows which has same "faculty_id" value, I want the below steps to be done
- Join/combine the data from both the csv files into 1 row, and ingest this row into ElasticSearch.
- If the left or right part in the join is empty, replace the empty with value 'null'
Find the below column header for CSV files,
Column Header of CSV1
Column Header of CVS2
Sample Input Data
Could anyone please guide me with the Logstash configuration to achieve the above mentioned scenario.