How to append two columns from different data inputs based on time

[pahujadeep]

I have data in below format 

Data Input 1 :  index=abc

Time (YYYY-MM-DD HH24)	Count1
2020-09-30 00	10
2020-09-30 01	20
2020-09-30 02	40

Data Input 2 : index=xyz

Time (YYYY-MM-DD HH24)	Count2
2020-09-30 00	30
2020-09-30 01	10
2020-09-30 02	25

I am looking for output like this :

Time (YYYY-MM-DD HH24)	Count1	Count2
2020-09-30 00	10	30
2020-09-30 01	20	10
2020-09-30 02	40	25

And create a timechart out of this for both values

[ITWhisperer · Accepted solution]

index=abc OR index=xyz
| stats values(Count1) as Count1 values(Count2) as Count2 by _time