To add to @yuanliu comment - the starting point to diagnose why something is NOT giving you what you expect is to isolate the simple example of a source from each where you do not get the results exp...
See more...
To add to @yuanliu comment - the starting point to diagnose why something is NOT giving you what you expect is to isolate the simple example of a source from each where you do not get the results expected. If you are unable to understand why it's not connecting the events as you suggest, post a sanitised example here, so we can help with different sets of eyes. stats is certainly the way to go. Does this example model what your data looks like | makeresults count=3
| eval field_A=split("ABC",""), field_D="text"
| mvexpand field_A
| eval field_E=mvindex(split("DOWN,UP",","),random() % 2)
| append [
| makeresults count=5
| eval field_B=split("ABC",""), field_C="F_C".(random() % 10)
| mvexpand field_B
]
| eval field_AB=coalesce(field_A, field_B)
| fields field_D field_E field_AB field_C
| stats values(*) as * by field_AB