Hi All, I have two sourcetypes in the same index, however the fields names are different but the value is same for the Email address of a user . But yet when i do a coalesce or use |where clause, splunk shows "No results found" For example: Sourcetype s1 contains email field while s2 contains user_email field. Both fields have same value:
[email protected] index=xx (sourcetype=s1 OR sourcetype=s2) (email=* OR user_email=*)
| eval user_id = coalesce(email, user_email)
OR
| index=xx (sourcetype=s1 OR sourcetype=s2)
| where email=user_email Result: No results found. I am following whatever is mentioned in https://community.splunk.com/t5/Splunk-Search/merge-two-sourcetypes-that-have-the-same-data-but-different/m-p/493244, but yet in my case it shows 0 Result matches. Any idea what can be the issue ? Is the @ sign or "." (dot) in the email id creating a problem ?
... View more