Splunk Search

Does lookup command support OR Boolean operation?

vpao
Engager

Hello,
I have events in index 1 and I have lookup table 1 created from a CSV file. I want to lookup events from index 1 in lookup table 1 by following a hierarchical logic:

  1. lookup where tail number OR flight ID OR operator matches
  2. AND lookup where airport matches

My search currently looks like this and it works. Is there a way to simplify it so that one lookup checks tail number then flight id then operator?
index=index1
| lookup lookuptable1 id as tailNo airport as iataAirport OUTPUT start_date/time as start_date
| lookup lookuptable1 id as flightId airport as iataAirport OUTPUTNEW start_date/time as start_date
| lookup lookuptable1 id as operator airport as iataAirport OUTPUTNEW start_date/time as start_date

Tags (2)
0 Karma

kbarker302
Communicator

lookup does not, but you may be able to achieve what you're looking for by using a KV Store instead.

See this link for configuring a KV Store from a CSV file:

http://docs.splunk.com/Documentation/Splunk/6.4.2/Knowledge/ConfigureKVstorelookups

And see this link for examples of using a where clause with the KV Store (in the "Filters and queries" section):

http://dev.splunk.com/view/SP-CAAAEZH

0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...