How to compare values from 2 different rows?

[efaundez]

Good afternoon

could someone help me with this query:

I have the following values

| users | Age |
  user1 | 99
  user2 | 99

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

[jacobpevans]

I downvoted this post because exact duplicate of: https://answers.splunk.com/answers/774701/how-to-compare-values-from-2-different-rows-1.html

[adonio]

closing it

[jacobpevans]

I downvoted this post because exact duplicate of: https://answers.splunk.com/answers/774701/how-to-compare-values-from-2-different-rows-1.html