# Get only one fileld that is common accoss different indices, like SQL join on tables

**URL:** https://discuss.elastic.co/t/get-only-one-fileld-that-is-common-accoss-different-indices-like-sql-join-on-tables/353677
**Category:** Elasticsearch
**Created:** [February 20, 2024, 11:08am UTC](https://discuss.elastic.co/t/get-only-one-fileld-that-is-common-accoss-different-indices-like-sql-join-on-tables/353677 "2024-02-20T11:08:14Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![PRASHANT\_MEHTA](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prashant_mehta/32/101764_2.png) [@PRASHANT\_MEHTA](https://discuss.elastic.co/u/PRASHANT_MEHTA)
#### Post date: [February 20, 2024, 11:08am UTC](https://discuss.elastic.co/t/get-only-one-fileld-that-is-common-accoss-different-indices-like-sql-join-on-tables/353677/1 "2024-02-20T11:08:14Z")

</div>

Hello All,

Can someone please let me know I have a requirement to make dashboard which shows which usecases/ index are critical to be shown with status Heathy in green color and Red Critical.  
Below is image I have achieved.  
Now I want to know a way how can I collect this common field "usecases.status","usecases.category" that is present in all index and send to another self made index, so that using common index only I can show which usecases are critical or healthy using TABLE VISUAL. I always want to show top hit values of field.  
With this I also see data duplication issue in seperate index, but as join don't work...I dont know better way to implement and avoid data duplication.

![image](https://us1.discourse-cdn.com/elastic/original/3X/3/1/31c26d0c61f6181bcf6b7967c4003a97b91c0745.png)

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 19, 2024, 11:08am UTC](https://discuss.elastic.co/t/get-only-one-fileld-that-is-common-accoss-different-indices-like-sql-join-on-tables/353677/2 "2024-03-19T11:08:19Z")

</div>

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