Splunk Search

How to only find matches where two tables have the same value?

Hergel
New Member

I have one table called CurrentValue and another called NextValue, I want to be able to only find results where CurrentValue and NextValue have the exact same value. How can I accomplish this?

Tags (2)
0 Karma
1 Solution

Suda
Communicator

Hello,

Could you try to use "where" command to compare 2 fields' value?

(your search) | where CurrentValue=NextValue 
  OR
(your search) | where 'CurrentValue'='NextValue' 

I hope it helps you.

Thank you.

View solution in original post

0 Karma

Hergel
New Member

Thanks, that worked 🙂

0 Karma

Suda
Communicator

Hello,

Could you try to use "where" command to compare 2 fields' value?

(your search) | where CurrentValue=NextValue 
  OR
(your search) | where 'CurrentValue'='NextValue' 

I hope it helps you.

Thank you.

0 Karma

Hergel
New Member

Thanks, that worked 🙂

0 Karma

strive
Influencer

CurrentValue and NextValue are tables right? the value should be same in any one column or multiple columns. Need more details to answer your question.

0 Karma
Get Updates on the Splunk Community!

Technical Workshop Series: Splunk Data Management and SPL2 | Register here!

Hey, Splunk Community! Ready to take your data management skills to the next level? Join us for a 3-part ...

Spotting Financial Fraud in the Haystack: A Guide to Behavioral Analytics with Splunk

In today's digital financial ecosystem, security teams face an unprecedented challenge. The sheer volume of ...

Solve Problems Faster with New, Smarter AI and Integrations in Splunk Observability

Solve Problems Faster with New, Smarter AI and Integrations in Splunk Observability As businesses scale ...