Help with alert search with join or append?

[VijaySrrie]

index=cat
	Name	Place	ID
	jack	delhi	1
	jill	melbourne	2
index=dog
	Country	number
	Australia	2
	India	1
ID field in cat and number field in dog are same, I need below output
	Name	Place	ID	Country
	jack	delhi	1	India
	jill	melbourne	2	Australia

[VijaySrrie · Accepted solution]

This answer worked for me

https://community.splunk.com/t5/Splunk-Search/Matching-fields-from-different-indices-to-return-anoth...

[ITWhisperer]

index=cat OR index=dog
| rename number as ID
| stats values(*) as * by ID

[VijaySrrie]

Hi @ITWhisperer ,

Thanks for the reply, I have pasted the answer that worked for me.