@renjith_nair @I'm sorry,this is not working for me. Let me explain it once again as I'm not sure if i had explained it right earlier. For say,below are the services,and few of them are in the lookup file. Services Service0- present in lookup Service45 Service05 Service078 - present in lookup Now,1.I should find the count of all the services whether present in lookup file or not. i.e.,a. service is present in log but not in lookup file b.service presnt in both log and lookup file c.service not present in log but in lookup file (in this case the count will be zero). 2.And for the service,the corresponding function(present in the same event) has to be fetched (i use regex to extract the function) (this will be applicable for a and b cases
... View more