# Join in Kibana
**URL:** https://discuss.elastic.co/t/join-in-kibana/88987
**Category:** Kibana
**Created:** [June 12, 2017, 8:15am UTC](https://discuss.elastic.co/t/join-in-kibana/88987 "2017-06-12T08:15:13Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Vaishali](https://discuss.elastic.co/u/Vaishali)
#### Post date: [June 12, 2017, 8:15am UTC](https://discuss.elastic.co/t/join-in-kibana/88987/1 "2017-06-12T08:15:14Z")
```
indent preformatted text by 4 spaces
```
Hi,
I'm new to ELK and trying to explore Kibana.
So far, I've read that it is not possible to join two indices so I'm trying to join two types under the same index.
Suppose, there is an index(Company) having two types in it: department and employee which share a common field i.e. deptId
department :
| deptId | deptName |
| --- | --- |
| 1001 | HR |
| 1002 | Finance |
| 1003 | Admin |
employee:
| empId | empName | depltId |
| --- | --- | --- |
| 1 | Ron | 1002 |
| 2 | Nancy | 1003 |
| 3 | Tara | 1001 |
I would like to know, if is it possible to display records as following, within the same visualization in Kibana:
| empId | empName | depltName |
| --- | --- | --- |
| 1 | Ron | Finance |
| 2 | Nancy | Admin |
| 3 | Tara | HR |
Thanks in advance.
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [June 12, 2017, 8:29am UTC](https://discuss.elastic.co/t/join-in-kibana/88987/2 "2017-06-12T08:29:51Z")
It is not possible as that is still a join.
---
### Author:  [@Vaishali](https://discuss.elastic.co/u/Vaishali)
#### Post date: [June 12, 2017, 9:03am UTC](https://discuss.elastic.co/t/join-in-kibana/88987/3 "2017-06-12T09:03:01Z")
Thanks Mark, but is there any work around or any kibana plugin available?
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [June 12, 2017, 9:06am UTC](https://discuss.elastic.co/t/join-in-kibana/88987/4 "2017-06-12T09:06:12Z")
Have you considered denormalising your data?
---
### Author:  [@Vaishali](https://discuss.elastic.co/u/Vaishali)
#### Post date: [June 12, 2017, 9:16am UTC](https://discuss.elastic.co/t/join-in-kibana/88987/5 "2017-06-12T09:16:41Z")
Unfortunately that option is not possible, as we would be matching patients genome data with reference genome data, which is very huge to denormalize.
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [June 12, 2017, 9:25am UTC](https://discuss.elastic.co/t/join-in-kibana/88987/6 "2017-06-12T09:25:14Z")
If you describe you data and what you are trying to achieve in greater detail, rather that trying to illustrate this with greatly simplified examples, you may get better and more relevant responses.
---
### Author:  [@Vaishali](https://discuss.elastic.co/u/Vaishali)
#### Post date: [June 12, 2017, 9:57am UTC](https://discuss.elastic.co/t/join-in-kibana/88987/7 "2017-06-12T09:57:24Z")
Sure.
we are trying to import genomic data(in GBs) and reference genome data(in GBs) in elastic search, and then display matching records by using a common column.
Result would be the genomic variation of user's data from reference data(annotation), which can be interpreted as a disease, reaction, etc.
Here, reference genome data is kind of static in nature.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 10, 2017, 9:57am UTC](https://discuss.elastic.co/t/join-in-kibana/88987/8 "2017-07-10T09:57:37Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.