I have created a list of 2000 names in a CSV file. I am trying to get the phone numbers of these 2000 people using the below query,
index=*** event=contact [ | inputlookup names.csv | fields names ] | stats dc(phoneNumber) by names | fillnull value=0 names
When I do the distinct count I only get the names who are registered, but I need the remaining names - dc(phone_numbers) as 0, when I run the query.
... View more