I have a sample CSV data of the form below:
ID, related ID, Event name, Date
1, 1001;1002, ABC,2016/01/01
1001, 1;1002, DEF,2016/01/02
1002, 1;1001, XYZ,2016/01/03
What I want as Output is:
ID, Event Name, Related Events, Date
So I want to fetch the records of "related ID" and display its corresponding Event name. This can be easily done in SQL. Any way to do the same in ES/Kibana?