How to check if two field match in SPLUNK

Question

number1= AnyNumber from 1 to 100 number2= AnyNumber from 1 to 100, This is how my data looks in Splunk

{[-]
   field1: number1,
   fiedl2: number2,
   ...
}

I want to check if these two fields match or doesn't, my Splunk Query

| search filed1 != field2
| stats count by field1,field2

Answer 1

Try using where with match:

<spl>
| where !match(field1,field2)
| stats count by field1 field 2

Answer 2

After adding the single quotes around the field2. I was able to get the data for the list of fields that are not matching! | where field1 != 'field2' | stats count by field1, field2