Hi All,
I am trying to write a search for extracting fields which are not matching with the lookup file or table. For example, I have the field named category and a lookup table with values similar to category in the index. Now I want to extract fields from the index which are not matching with values in the lookup table. Please help me in writing the search.
Thank you in advance
i have url category, url, username fields in the index and url category in the lookup
Generally, like this:
... NOT [|inputlookup MyLookup | fields MyFieldToNotMatch]
Just put your base search in place of the ellipsis ( ...
).
Can you provide name of fields in the index and all fields available in lookup?