How to only find matches where two tables have the same value?

[Hergel]

I have one table called CurrentValue and another called NextValue, I want to be able to only find results where CurrentValue and NextValue have the exact same value. How can I accomplish this?

[Hergel]

Thanks, that worked 🙂

[Suda · Accepted solution]

Hello,

Could you try to use "where" command to compare 2 fields' value?

(your search) | where CurrentValue=NextValue 
  OR
(your search) | where 'CurrentValue'='NextValue' 

I hope it helps you.

Thank you.

[Hergel]

Thanks, that worked 🙂

[strive]

CurrentValue and NextValue are tables right? the value should be same in any one column or multiple columns. Need more details to answer your question.