Example Lookup Table entries:
fieldA fieldB
value value
value 'blank'
value value
Show events where 'fieldA' matches but exclude events where 'fieldB' is blank, within the lookup table. 'fieldB' does not exist in any of the events.
Test query (that does not work):
| lookup fieldA | search fieldB != ""
I believe the query above will match events that contain 'fieldA' but then searches the events where fieldB is blank within the event. Again, the events do not contain 'fieldB' and I'm not looking to append any other fields within the lookup table.
... View more