# How to show retrieve all data fields of 2 indexes in same data table visualization
**URL:** https://discuss.elastic.co/t/how-to-show-retrieve-all-data-fields-of-2-indexes-in-same-data-table-visualization/264223
**Category:** Kibana
**Created:** [February 13, 2021, 6:29pm UTC](https://discuss.elastic.co/t/how-to-show-retrieve-all-data-fields-of-2-indexes-in-same-data-table-visualization/264223 "2021-02-13T18:29:18Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Sandeep\_Raju](https://discuss.elastic.co/u/Sandeep_Raju)
#### Post date: [February 13, 2021, 6:29pm UTC](https://discuss.elastic.co/t/how-to-show-retrieve-all-data-fields-of-2-indexes-in-same-data-table-visualization/264223/1 "2021-02-13T18:29:18Z")
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.
---
### Author:  [@ylasri](https://discuss.elastic.co/u/ylasri)
#### Post date: [February 14, 2021, 3:19pm UTC](https://discuss.elastic.co/t/how-to-show-retrieve-all-data-fields-of-2-indexes-in-same-data-table-visualization/264223/2 "2021-02-14T15:19:49Z")
Make sure both indexes ara having same pattern like :
```auto
index-data-domain1
index-data-domain2
```
Then all you need is to create an index pattern like this from Kibana
```auto
index-data-*
```
---
### Author:  [@Sandeep\_Raju](https://discuss.elastic.co/u/Sandeep_Raju)
#### Post date: [February 14, 2021, 3:34pm UTC](https://discuss.elastic.co/t/how-to-show-retrieve-all-data-fields-of-2-indexes-in-same-data-table-visualization/264223/3 "2021-02-14T15:34:38Z")
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?
---
### Author:  [@ylasri](https://discuss.elastic.co/u/ylasri)
#### Post date: [February 14, 2021, 3:54pm UTC](https://discuss.elastic.co/t/how-to-show-retrieve-all-data-fields-of-2-indexes-in-same-data-table-visualization/264223/4 "2021-02-14T15:54:04Z")
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 |
---
### Author:  [@Sandeep\_Raju](https://discuss.elastic.co/u/Sandeep_Raju)
#### Post date: [February 14, 2021, 4:02pm UTC](https://discuss.elastic.co/t/how-to-show-retrieve-all-data-fields-of-2-indexes-in-same-data-table-visualization/264223/5 "2021-02-14T16:02:16Z")
Thank you for response
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 14, 2021, 4:02pm UTC](https://discuss.elastic.co/t/how-to-show-retrieve-all-data-fields-of-2-indexes-in-same-data-table-visualization/264223/6 "2021-03-14T16:02:54Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.