Kindly help on the below scenario where I need to compare two different columns created using different sourcetype. For Ex: |appendcols [search index="X" sourcetype="xy" |table ID,CASE_ID|] [search index="X" sourcetype="YZ" OR sourcetype="ABC"|table Role,Name,NewID| Now here, I need to Match ID and NewID which has similar results but not is same row. ID NewID 123 789 456 123 789 987 987 456 Now, the result should come match for the data. I have tried many ways like (|foreach ID [eval status =if (match (ID, NewID), "YES", "NO")]. But nothing worked . Please provide you suggestion.
... View more