# Joining two files in elasticsearch
**URL:** https://discuss.elastic.co/t/joining-two-files-in-elasticsearch/73343
**Category:** Elasticsearch
**Created:** [January 31, 2017, 10:35am UTC](https://discuss.elastic.co/t/joining-two-files-in-elasticsearch/73343 "2017-01-31T10:35:37Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@amol\_sonawane1](https://discuss.elastic.co/u/amol_sonawane1)
#### Post date: [January 31, 2017, 10:35am UTC](https://discuss.elastic.co/t/joining-two-files-in-elasticsearch/73343/1 "2017-01-31T10:35:38Z")
Hi
I want to index two files and after that I wanted to join the result from both the files.
Suppose I have one or more common columns in both the files and have no of columns which are different in both the files. but while retrieving or visualizing the data in kibana, I wanted to the show result on basis of common columns just like the join queries in RDBMS.
Is it possible in Elasticsearch & kibana??
Thanks in advance.
---
### Author:  [@mnozawa](https://discuss.elastic.co/u/mnozawa)
#### Post date: [February 1, 2017, 11:25am UTC](https://discuss.elastic.co/t/joining-two-files-in-elasticsearch/73343/2 "2017-02-01T11:25:39Z")
Hi,
I don't understand everything you want, maybe "terms aggregation" for the common column (field in Elasticsearch) support you.
[https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 1, 2017, 11:25am UTC](https://discuss.elastic.co/t/joining-two-files-in-elasticsearch/73343/3 "2017-03-01T11:25:49Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.