Hi  Yes, i tried to state the field i wanted to join.  I am writing this query with dummy fields.  In short there are two source types and i want CompletionTime_Dep and CompletionTime_CD in the final table       index=abc sourcetype="xyz" "efp" source="hello1" OR source="hello2*" OR source="hello3*"  | rex field=source (?<Tweet>"\b\w{2}\b")  | eval Steel = case(Tweet == "EV", "Steel1", Tweet == "SV", "Steel2")  | table Tweet Steel _time  | rename _time as CompletionTime_Dep  | convert ctime(CompletionTime_Dep)  | join Steel type=left  [ search sourcetype="ufh" "stn" source="hello1" OR source="hello2*" OR source="hello3*"  rex field=source (?<Tweet>"\b\w{2}\b")  | eval Steel = case(Tweet == "EV", "Steel1", Tweet == "SV", "Steel2")  | table Tweet Steel _time  | rename _time as CompletionTime_CD  | convert ctime(CompletionTime_CD)]     
						
					
					... View more