# How to merge columns from different Index?
**URL:** https://discuss.elastic.co/t/how-to-merge-columns-from-different-index/124031
**Category:** Kibana
**Created:** [March 15, 2018, 6:00am UTC](https://discuss.elastic.co/t/how-to-merge-columns-from-different-index/124031 "2018-03-15T06:00:56Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@amit\_ahuja](https://discuss.elastic.co/u/amit_ahuja)
#### Post date: [March 15, 2018, 6:00am UTC](https://discuss.elastic.co/t/how-to-merge-columns-from-different-index/124031/1 "2018-03-15T06:00:57Z")
Hello ,
I have a index-1 where i have col1,col2,col2.... and i have another index index-2 where i have col1,lat,long..
col1 is present in both index 1 and index 2 .
my requirement is to show aggregation on index 1 values and using visual map with index 2 values.
but it is not working as both are having diffferent records .though i can see all fields coming from both indexes because name are index\* . but aggregation not filtering based on lat,long selected.
so is there any way i can merge these 3 cols in to index-1 or any other way i can use both index-\* ( index-1 and index-2) in same dashboard ?
Thanks
Amit
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [March 15, 2018, 7:28am UTC](https://discuss.elastic.co/t/how-to-merge-columns-from-different-index/124031/2 "2018-03-15T07:28:54Z")
I moved your question to #kibana as I believe this is where you can solve that use case.
You can add on a dashboard visualizations coming from different indices.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 12, 2018, 7:29am UTC](https://discuss.elastic.co/t/how-to-merge-columns-from-different-index/124031/3 "2018-04-12T07:29:02Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.