How to compare two fields between two lookups?

kiran331 · ‎10-07-2016

Hello

How to compare two lookups with by two fields? I have two fields: host and process in both lookup1 and lookup2. I have to compare to get the processes which are not in lookup1 by host?

somesoni2 · ‎10-07-2016

Try like this

|inputlookup lookup1.csv | lookup lookup2.csv host process OUTPUT process as testfield | where isnull(testfield)

OR

|inputlookup lookup1.csv | search NOT [ |inputlookup lookup2.csv | table host process]

How to compare two fields between two lookups?

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Index This | What travels the world but is also stuck in place?

Discover New Use Cases: Unlock Greater Value from Your Existing Splunk Data

Continue Your Journey: Join Session 2 of the Data Management and Federation Bootcamp ...

Join the Conversation

How to compare two fields between two lookups?

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Index This | What travels the world but is also stuck in place?

Discover New Use Cases: Unlock Greater Value from Your Existing Splunk Data

Continue Your Journey: Join Session 2 of the Data Management and Federation Bootcamp ...