https://community.splunk.com/t5/Splunk-Search/How-to-only-find-matches-where-two-tables-have-the-same-value/m-p/166902#M47507 <P>Thanks, that worked <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 01 Aug 2014 11:52:59 GMT Hergel 2014-08-01T11:52:59Z https://community.splunk.com/t5/Splunk-Search/How-to-only-find-matches-where-two-tables-have-the-same-value/m-p/166899#M47504 <P>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?</P> Fri, 01 Aug 2014 09:00:00 GMT https://community.splunk.com/t5/Splunk-Search/How-to-only-find-matches-where-two-tables-have-the-same-value/m-p/166899#M47504 Hergel 2014-08-01T09:00:00Z https://community.splunk.com/t5/Splunk-Search/How-to-only-find-matches-where-two-tables-have-the-same-value/m-p/166900#M47505 <P>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.</P> Fri, 01 Aug 2014 10:40:29 GMT https://community.splunk.com/t5/Splunk-Search/How-to-only-find-matches-where-two-tables-have-the-same-value/m-p/166900#M47505 strive 2014-08-01T10:40:29Z https://community.splunk.com/t5/Splunk-Search/How-to-only-find-matches-where-two-tables-have-the-same-value/m-p/166901#M47506 <P>Hello,</P> <P>Could you try to use "where" command to compare 2 fields' value?</P> <PRE><CODE>(your search) | where CurrentValue=NextValue OR (your search) | where 'CurrentValue'='NextValue' </CODE></PRE> <P>I hope it helps you.</P> <P>Thank you.</P> Fri, 01 Aug 2014 11:07:55 GMT https://community.splunk.com/t5/Splunk-Search/How-to-only-find-matches-where-two-tables-have-the-same-value/m-p/166901#M47506 Suda 2014-08-01T11:07:55Z https://community.splunk.com/t5/Splunk-Search/How-to-only-find-matches-where-two-tables-have-the-same-value/m-p/166902#M47507 <P>Thanks, that worked <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 01 Aug 2014 11:52:59 GMT https://community.splunk.com/t5/Splunk-Search/How-to-only-find-matches-where-two-tables-have-the-same-value/m-p/166902#M47507 Hergel 2014-08-01T11:52:59Z https://community.splunk.com/t5/Splunk-Search/How-to-only-find-matches-where-two-tables-have-the-same-value/m-p/166903#M47508 <P>Thanks, that worked <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 01 Aug 2014 11:53:19 GMT https://community.splunk.com/t5/Splunk-Search/How-to-only-find-matches-where-two-tables-have-the-same-value/m-p/166903#M47508 Hergel 2014-08-01T11:53:19Z