Compare a field with lookup file

[praneshjan]

I was trying to compare searched result with lookup file.
Is there any to compare results with lookup file.

|mysearch
|append[|inputlookup lookupname|field Lookupfield]
|where searched=lookupfield

this was my search trying but it is not working.

[sheamus69]

How about:

... mysearch |lookup lookupname lookupnamefield OUTPUT lookupnamefield as dummy|where isnotnull(dummy)

[jkat54]

Try this:

 ... mysearch [|inputlookup lookupname | fields lookupField|format]

Will unpack to this:

... mysearch ((lookupField=valueFromLookupRow1) OR (lookupField=valueFromLookupRow2) OR ... )