How to extract fields from an index that do not match with values in a lookup table?

[avis1119]

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

[avis1119]

i have url category, url, username fields in the index and url category in the lookup

[woodcock]

Generally, like this:

... NOT [|inputlookup MyLookup | fields MyFieldToNotMatch]

Just put your base search in place of the ellipsis ( ... ).

[somesoni2]

Can you provide name of fields in the index and all fields available in lookup?