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.
Thanks, that worked 🙂
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.
Thanks, that worked 🙂
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.