I have a Lookup "Consumer_Lookup.csv" (30 rows approx)
Search - Index = "xyz" |stats count(Status) AS Total by ClientId|Table ClientId TOtal
my requirement is to find any Consumer in Lookup with Restricted = "Y" not in the search result. Can you please advise on how to proceed. Should I use Join or any other alternative .
Thanks for your help!!