Join two csv file and modify the data

Elastic Stack Elasticsearch
1

I have two CSV files . I want to merge two CSV files based on common column Location and get the DEPT value in o/p . Please help me.

CSV1
Location Maximum Dept
High School1 25
High School2 25

CSV2
Location Category Dept
High School1 1 Sales
High School2 2 OPERATIONS

o/p
Location Maximum Dept
High School1 25 Sales
High School2 25 OPERATIONS

2

You need to do the join at index time ideally.
So do that in your application or use an ETL like logstash may be.

3

Thanks for the reply.
Can you share the sample configfile

4

I don't have such a thing.

5

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.