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.
How about:
... mysearch |lookup lookupname lookupnamefield OUTPUT lookupnamefield as dummy|where isnotnull(dummy)
Try this:
... mysearch [|inputlookup lookupname | fields lookupField|format]
Will unpack to this:
... mysearch ((lookupField=valueFromLookupRow1) OR (lookupField=valueFromLookupRow2) OR ... )