I have 1 index in elasticsearch that I want to aggregate 2 CSV files data. So, I create the index and the mapping:
mapping with the fields: ID, Date, Name, Reference, Subject, Operator
I have 2 CSV files, let's supose:
ID, Date, Name
Identifier, Ref, Subject, Operator
How can I match the column "Identifier" from file2 with "ID" from file1?
And one more question:
I have different pipelines to each file... So, one pipeline import file1 and match the fields that file contains, and same appends with file2..
Can you help me to do that?