Hello @SplunkDash, Can you please check below - | makeresults
| eval _raw="accid,nameA,addressA,cellA
002,test1,tadd1,1234
003,test2,tadd2,1256
003,test2,tadd2,5674
004,test3,tadd3,2345
005,test4,tadd4,4567
006,test5,tadd5,7800
006,test5,tadd5,9900"
| multikv forceheader=1
| eval sourcetype="sourcetypeA"
| append
[| makeresults
| eval _raw="accid,nameB,addressB,cellB
002,test1,tadd1,1234
003,test2,tadd2,5674
004,test3,tadd3,2345
005,test4,tadd3,4567
006,test5,tadd5,9900"
| multikv forceheader=1
| eval sourcetype="sourcetypeB"
]
| kv
| stats values(*) as * by accid
| where mvcount(nameA) != mvcount(nameB) OR mvcount(addressA) != mvcount(addressB) OR mvcount(cellA) != mvcount(cellB) Please let me know if you have any questions for the above. Please accept the solution and hit Karma, if this helps!
... View more