# Data visualisation from different datasets

**URL:** <https://discuss.elastic.co/t/data-visualisation-from-different-datasets/123409>\
**Category:** Kibana\
**Created:** [March 11, 2018, 6:05am UTC](https://discuss.elastic.co/t/data-visualisation-from-different-datasets/123409 "2018-03-11T06:05:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Errors](https://avatars.discourse-cdn.com/v4/letter/e/a9adbd/32.png) [@Errors](https://discuss.elastic.co/u/Errors)\
**Post date:** [March 11, 2018, 6:05am UTC](https://discuss.elastic.co/t/data-visualisation-from-different-datasets/123409/1 "2018-03-11T06:05:12Z")

</div>

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? 🙂

---

<div class="post-metadata">

**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\
**Post date:** [March 12, 2018, 1:34pm UTC](https://discuss.elastic.co/t/data-visualisation-from-different-datasets/123409/2 "2018-03-12T13:34:13Z")

</div>

Hey @Errors if you modify the way that you're ingesting documents into Elasticsearch by using Logstash or the Elasticsearch Ingest Node to extract the first\_name from the full\_name field, then you can create a Visualization that performs a terms aggregation on the first\_name to determine where it's missing similar to:

 ![53%20AM](https://us1.discourse-cdn.com/elastic/original/3X/6/2/62a93cc3969004b1f55409b778e9ad310b87afa5.png)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [April 9, 2018, 1:34pm UTC](https://discuss.elastic.co/t/data-visualisation-from-different-datasets/123409/3 "2018-04-09T13:34:13Z")

</div>

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