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

Elastic Stack Kibana
1

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.

2

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-*
3

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?

4

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
5

Thank you for response

6

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.