So I've got a small problem, I have two different datasets with two quite different kinds of mappings for each. One's xml data, the others from a csv. Essentially, I want to compare a certain field from each dataset to see if theres any sort of match and visualise that using kibana. The fieldnames from each dataset are entirely different and thus their mappings are different as well (I have pushed the data from both datasets into the same index in elasticsearch)
From the xml data, I'm looking to take the 'first_name' field and compare it with the field 'full_name' from the csv. Essentially if the 'first_name' value exists within the 'full_name', I would want a result to appear (perhaps I would need to make a script to do this to just show those results? If so, how would that script look?)
At the moment I'm not sure on how to proceed and I haven't been able to find much help online. Does anyone have any sort of solution?