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