Is it possible combine two index together in Kibana

[AKumar123 (Anant Kumar)]

I have two index data which i am using in kibana.For that I created Visulazation as well and able to see Data in dashboard.

But challange is when i am filtering data for Index1 after clicking on +Button other index data is not appearing,Same thing is happening for Index2 as well.

Is it possible to combine both the index together.

[AKumar123 (Anant Kumar)]

[AKumar123 (Anant Kumar)]

[mattkime (Matthew Kime)]

Hello @AKumar123

Is the field and value available in both data sets?

Could you show the config for each visualization?

[AKumar123 (Anant Kumar)]

[AKumar123 (Anant Kumar)]

Value is same in both the Data Set,But Field name is different.If I make field name same it replaces the values.

I combine both the indexes with index* also..

[mattkime (Matthew Kime)]

I'd recommend creating a field alias on one index so that both sets of data can use the same field name - https://www.elastic.co/guide/en/elasticsearch/reference/master/alias.html

[AKumar123 (Anant Kumar)]

can not create one Index becasue other data coming from different system.

[mattkime (Matthew Kime)]

Then you need to write an OR query that addresses both fields.

[AKumar123 (Anant Kumar)]

what is OR Query how can we achieve in UI Level

[mattkime (Matthew Kime)]

Use the search bar - fieldname: value OR fieldname: value

[AKumar123 (Anant Kumar)]

search is working fine for both indexes.Filter not working.

[mattkime (Matthew Kime)]

You need to click 'edit query dsl' - this PR has examples - https://github.com/elastic/kibana/pull/5109#issuecomment-151600967