I have two data sets that I want to join:
Set A: _time, field1, field2, field3...
via search: eventtype=mystats | fields _time, field1, field2, field3...
Set B: _raw
via search: eventype=mydata | tranaction .... | closed_txn = 0 | where _time >= "Set A _time - 5 seconds" AND _time <= "Set A _time + 5 seconds" | fields _raw
The result should be simply appending all Set B _raw that match to the rows of Set A.
Set A+B: _time, field1, field2, field3, _raw
Is this possible with a subsearch to iterate over time or join by time while passing the _time around? I am not sure what the right approach is but I am trying to find open transactions in set B around a window of events in Set A (which ticks every 30 seconds)
... View more