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