I have a large CSV lookup table operational and working well but would like to run a search on my data that only shows values that are NOT in the table. Any ideas?
If no result is found, the default is “Definition Not defined”.
Generally you could run a subsearch with your CSV lookup table to filter your indexed data (e.g. index=foo sourcetype=bar NOT [| inputlookup yourLookup.csv | table field1 field1.. | format]). With little information in the question about your lookup table, your indexed data search and their relationship, I would suggest give something like above a try. Providing more information in your question would yield you better suggestion from the community.