# How do I relate 2 objects with no common field?

**URL:** <https://discuss.elastic.co/t/how-do-i-relate-2-objects-with-no-common-field/280688>\
**Category:** Kibana\
**Tags:** docker\
**Created:** [August 6, 2021, 10:13pm UTC](https://discuss.elastic.co/t/how-do-i-relate-2-objects-with-no-common-field/280688 "2021-08-06T22:13:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![creativeguitar](https://avatars.discourse-cdn.com/v4/letter/c/ce73a5/32.png) [@creativeguitar](https://discuss.elastic.co/u/creativeguitar)\
**Post date:** [August 6, 2021, 10:13pm UTC](https://discuss.elastic.co/t/how-do-i-relate-2-objects-with-no-common-field/280688/1 "2021-08-06T22:13:51Z")

</div>

Input Data:

```auto
* Operating Systems CSVs
  * Fields: OperatingSystem, general_availability, end_of_life
  * Examples: 
     * OperatingSystem------ general_availability------end_of_life
     * RHEL 7.9-------------------------01/01/2018 --------01/01/2024
     * CentOS 7.9----------------------01/01/2017---------01/01/2024
     * Windows 2016-----------------01/01/2016---------01/01/2020

* Applications CSVs
  * Fields: ApplicationName, general_availability, end_of_life
  * Examples: 
     * ApplicationName-------general_availability------end_of_life
     * Apache 2.4---------------------01/01/2018 --------01/01/2024
     * Docker 6.2------ ---------------01/01/2017---------01/01/2024
     * NetBackup 9.2- - -------------01/01/2016---------01/01/2020

```

I would like to define some relationships, for example: (I dont mind creating a 3csv with the relationships)

- RHEL 7.9 - (apache 2.4, Docker 6.2)
- CentOS 7.9 - (Apache 2.4)
- Windows 2016 -(Docker 6.2, NetBackup 9.2)

Lastly If I had a dashboard with 1 filter for OperatingSystems & 2 tables, one with Operating systems and its dates and other one with Applications and its dates. (I know how to build tables and filters), I would like if I select "RHEL 7.9" for the applications table to show Apache 2.4 and Docker 6.2 with both general\_availability and end\_of\_life dates

End Result:

```auto
Filter: "RHEL 7.9"

     Table 1:
     OperatingSystem------ general_availability------end_of_life
     RHEL 7.9------------------01/01/2018 -------------01/01/2024
     
     Table 2:
     ApplicationName-------general_availability------end_of_life
     Apache 2.4------------------01/01/2018 -----------01/01/2024
     Docker 6.2------ ------------01/01/2017-----------01/01/2024

```

All this data(CSVs) is getting ingested by logstash and sent to elasticsearch

---

<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:** [September 3, 2021, 10:14pm UTC](https://discuss.elastic.co/t/how-do-i-relate-2-objects-with-no-common-field/280688/2 "2021-09-03T22:14:43Z")

</div>

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