Splunk Search

compare row by row values

kirrusk
Communicator

Hi All,

 

i'm trying to compare row values .

my table is like 

 

App           label                   env         space

mini1       jenkins-a21        p1          1290           

mini2       jenkins-a22       p1            1687

mini2      jenkins-a21         p2          1290

mini3       jenkins-a23         p2           1598

mini4      jenkins-a24          p1           1687

mini3       jenkins-b23          p1           1598

 

output should be like 

App           label                      env           space          Result

mini1       jenkins-a21          p1            1290       matched       (comparing label values for p1 and p2)

mini2       jenkins-a21          p2           1290        matched       (comparing label value for p1 and p2)

mini3       jenkins-a23         p2           1598         not matched (comparing  label value for p1 and p2

mini3       jenkins-b23          p1           1598        not matched   (comparing label label for p1 and p2)

 

@woodcock 

0 Karma

richgalloway
SplunkTrust
SplunkTrust

It's not clear what the goal is.  Please provide a sample of the desired output.

---
If this reply helps you, Karma would be appreciated.
0 Karma

kirrusk
Communicator

@richgalloway  updated question

0 Karma
Get Updates on the Splunk Community!

Splunk Classroom Chronicles: Training Tales and Testimonials (Episode 4)

Welcome back to Splunk Classroom Chronicles, our ongoing series where we shine a light on what really happens ...

From GPU to Application: Monitoring Cisco AI Infrastructure with Splunk Observability ...

AI workloads are different. They demand specialized infrastructure—powerful GPUs, enterprise-grade networking, ...

Application management with Targeted Application Install for Victoria Experience

  Experience a new era of flexibility in managing your Splunk Cloud Platform apps! With Targeted Application ...