For back ground please check the accepted answer for :
Best way to check email logs for recipients that are on a list
Scenario:
Searching for emails with a specific subject.
Need to know if any recipients are on a watch_list.csv (this has been accomplished by the following from somesoni2)
.... | lookup watch_list.csv emailaddress as recp OUTPUT flag | eval on_list=if(flag=1,"yes","no") | fields - flag ....
However, now I need the yes and the emailaddress that match the emailaddress on the watch_list.csv
Please provide an example.
Thank you
... View more