topic Re: How to compare values from 2 different rows? in Splunk Search

How to compare values from 2 different rows?

efaundez — Thu, 03 Oct 2019 18:08:15 GMT

Good afternoon

could someone help me with this query:

I have the following values

How can I compare that if the user user1 of age 99 is equal to the user of age 99, then OK?

The field that has these users is called user and age has the values for each user

Any help is appreciated

Regards

Re: How to compare values from 2 different rows?

jacobpevans — Thu, 03 Oct 2019 18:37:56 GMT

Can you further clarify? Are you comparing user1=user2 or age of user1 = age of user2? What does OK mean?

Re: How to compare values from 2 different rows?

adonio — Thu, 03 Oct 2019 18:44:59 GMT

maybe try something like this:

| makeresults count=1
| eval user="bob,rob,todd,jon,max,ben"
| makemv delim="," user
| mvexpand user
| eval age = random()%4
| stats values(user) as all_users_with_same_age by age
| eval OK = if(mvcount(all_users_with_same_age) > 1,"OK","NOT OK")

hope it helps