How to show retrieve all data fields of 2 indexes in same data table visualization

Hi all,

In kibana, i have 2 indexes with a common field .

I want to retrieve all data fields of 2 indexes in same data table visualization based on 1 common field something like vlookup in excel.

For Example, i have 2 indexes with common field 'Country_name'.I want to get values of 2nd index in the same row of data table visualization.

Make sure both indexes ara having same pattern like :

index-data-domain1
index-data-domain2

Then all you need is to create an index pattern like this from Kibana

index-data-*

Hi Yassine,

I'm having 2 indexes:

Index_data_1:
country_name country_currency
GER EURO
USA DOLLAR

Index_data_2:
country_name country_code
GER 4765
USA 8345

Now im having index pattern index_data_*

I'm trying to retrive table like this:
country_name country_currency country_code
GER EURO 4765
USA DOLLAR 8345

But i'm getting a table like this:
country_name country_currency country_code
GER EURO missing
USA DOLLAR missing
GER missing 4765
USA missing 8345

Any idea on how to go about this?

This will not be possible, you have to merge these data into one index :

country_name country_currency country_code
GER EURO 4765
USA DOLLAR 8345

Thank you for response