# How to execute a combined index search in Kibana / Elasticsearch?
**URL:** https://discuss.elastic.co/t/how-to-execute-a-combined-index-search-in-kibana-elasticsearch/177740
**Category:** Kibana
**Created:** [April 21, 2019, 3:15am UTC](https://discuss.elastic.co/t/how-to-execute-a-combined-index-search-in-kibana-elasticsearch/177740 "2019-04-21T03:15:03Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Niranga\_Jayakody](https://discuss.elastic.co/u/Niranga_Jayakody)
#### Post date: [April 21, 2019, 3:15am UTC](https://discuss.elastic.co/t/how-to-execute-a-combined-index-search-in-kibana-elasticsearch/177740/1 "2019-04-21T03:15:03Z")
I have two .csv files called Bus.csv & Tuk.csv and i have successfully imported these two files to elastcsearch. using kibana i can do the visualisation and search
**How can execute a combined search/discover query using both documents data in Kibana ??**
e.g - search
`select * "Mobile Number" from (both csv) where "Amount > 1,000"`
**Bus.csv - Columns**
1. Mobile Number
2. Age
3. Amount
**Tuk.csv - Columns**
1. Mobile Number
2. Gender
3. Amount
4. Mobile Type
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [April 21, 2019, 4:57am UTC](https://discuss.elastic.co/t/how-to-execute-a-combined-index-search-in-kibana-elasticsearch/177740/2 "2019-04-21T04:57:19Z")
You will need an index alias across both indices that you then setup in Kibana as an index pattern.
---
### Author:  [@Niranga\_Jayakody](https://discuss.elastic.co/u/Niranga_Jayakody)
#### Post date: [April 21, 2019, 6:05am UTC](https://discuss.elastic.co/t/how-to-execute-a-combined-index-search-in-kibana-elasticsearch/177740/3 "2019-04-21T06:05:33Z")
how do i create index alias ?? any help be appreciated
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [April 21, 2019, 6:11am UTC](https://discuss.elastic.co/t/how-to-execute-a-combined-index-search-in-kibana-elasticsearch/177740/4 "2019-04-21T06:11:01Z")
Check out [https://www.elastic.co/guide/en/elasticsearch/reference/7.0/indices-aliases.html](https://www.elastic.co/guide/en/elasticsearch/reference/7.0/indices-aliases.html)
---
### Author:  [@Niranga\_Jayakody](https://discuss.elastic.co/u/Niranga_Jayakody)
#### Post date: [April 21, 2019, 6:29am UTC](https://discuss.elastic.co/t/how-to-execute-a-combined-index-search-in-kibana-elasticsearch/177740/5 "2019-04-21T06:29:14Z")
Thanks and it working., 🙂
- now i need to remove duplicated and merge, is there a function in kibana for this !
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [April 21, 2019, 7:55am UTC](https://discuss.elastic.co/t/how-to-execute-a-combined-index-search-in-kibana-elasticsearch/177740/6 "2019-04-21T07:55:35Z")
Duplicate what? They're totally different records.
---
### Author:  [@Niranga\_Jayakody](https://discuss.elastic.co/u/Niranga_Jayakody)
#### Post date: [April 21, 2019, 8:19am UTC](https://discuss.elastic.co/t/how-to-execute-a-combined-index-search-in-kibana-elasticsearch/177740/7 "2019-04-21T08:19:42Z")
so in this files if you take column "Mobile Number" has some documents that are repeating.
e.g same Mobile number in both files
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 19, 2019, 8:28am UTC](https://discuss.elastic.co/t/how-to-execute-a-combined-index-search-in-kibana-elasticsearch/177740/8 "2019-05-19T08:28:54Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.