Another option you may consider is
SourceType=”A” | stats values(A1) as A1, values(A2) as A2 by common_field
SourceType=”B” | stats values(B1) as B1, values(B2) as B2 by common_field.
and build the table later
transaction common_field | table common_field, A1, A2, B1, B2
My question is it quicker to use a summary indexes than the raw logs? Another option is to use two summary indexes, one is fields A's and the second is fields A and B.
I hope something here helps...
... View more