topic Re: values mismatch in Splunk Search

values mismatch

akumar — Sun, 15 Nov 2020 21:35:16 GMT

i have issue where i am comparing values from 2 fields which will have same value always, but sometimes it differs. I want to compare between these two feilds and have status as Match or Mismatch. I have having issues where even if both fields have some value its showing as mismatch in status.

| eval CheckMatch = if(f1==f2,"Match", "Mismatch")

Below is the sample result

f1 f2 CheckMatch
14552.06 14552.06 Mismatch

Re: values mismatch

ITWhisperer — Mon, 16 Nov 2020 08:24:09 GMT

Are the fields of the same type, e.g. both numeric or both strings? Is either one a multivalue field?

Re: values mismatch

akumar — Mon, 16 Nov 2020 18:01:01 GMT

Both are numeric values only. But before applying this match condition I am adding 2 field of values to F1 ( f1=a+b).

Re: values mismatch

ITWhisperer — Mon, 16 Nov 2020 18:07:17 GMT

Is there any rounding going on in the way the numbers are presented? Is it worth trying

| eval CheckMatch = if(round(f1,2)==round(f2,2),"Match", "Mismatch")

Re: values mismatch

akumar — Mon, 16 Nov 2020 18:32:38 GMT

I tried using your above command, now it’s matching all fields even if the values are not the same.

Re: values mismatch

akumar — Mon, 16 Nov 2020 18:39:09 GMT

please see below is the search I am using and the result set

Re: values mismatch

ITWhisperer — Mon, 16 Nov 2020 18:41:14 GMT

Are they being treated as strings? What do you get with

| eval f1number=tonumber(f1) | eval f2number=tonumber(f2)