https://community.splunk.com/t5/Splunk-Search/compare-row-by-row-values/m-p/532199#M150343 <P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/213957">@richgalloway</a>&nbsp; updated question</P> Mon, 07 Dec 2020 14:31:21 GMT kirrusk 2020-12-07T14:31:21Z https://community.splunk.com/t5/Splunk-Search/compare-row-by-row-values/m-p/532184#M150337 <P>Hi All,</P><P>&nbsp;</P><P>i'm trying to compare row values .</P><P>my table is like&nbsp;</P><P>&nbsp;</P><P>App&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;label&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;env&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;space</P><P>mini1&nbsp; &nbsp; &nbsp; &nbsp;jenkins-a21&nbsp; &nbsp; &nbsp; &nbsp; p1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1290&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P><P>mini2&nbsp; &nbsp; &nbsp; &nbsp;jenkins-a22&nbsp; &nbsp; &nbsp; &nbsp;p1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1687</P><P>mini2&nbsp; &nbsp; &nbsp; jenkins-a21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;p2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1290</P><P>mini3&nbsp; &nbsp; &nbsp; &nbsp;jenkins-a23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;p2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1598</P><P>mini4&nbsp; &nbsp; &nbsp; jenkins-a24&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; p1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1687</P><P>mini3&nbsp; &nbsp; &nbsp; &nbsp;jenkins-b23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; p1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1598</P><P>&nbsp;</P><P>output should be like&nbsp;</P><P>App&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;label&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; env&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;space&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Result</P><P>mini1&nbsp; &nbsp; &nbsp; &nbsp;jenkins-a21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; p1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1290&nbsp; &nbsp; &nbsp; &nbsp;matched&nbsp; &nbsp; &nbsp; &nbsp;(comparing label values for p1 and p2)</P><P>mini2&nbsp; &nbsp; &nbsp; &nbsp;jenkins-a21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; p2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1290&nbsp; &nbsp; &nbsp; &nbsp; matched&nbsp; &nbsp; &nbsp; &nbsp;(comparing label value for p1 and p2)</P><P>mini3&nbsp; &nbsp; &nbsp; &nbsp;jenkins-a23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;p2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1598&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;not matched (comparing&nbsp; label value for p1 and p2</P><P>mini3&nbsp; &nbsp; &nbsp; &nbsp;jenkins-b23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; p1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1598&nbsp; &nbsp; &nbsp; &nbsp; not matched&nbsp; &nbsp;(comparing label label for p1 and p2)</P><P>&nbsp;</P><P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/1406">@woodcock</a>&nbsp;</P> Wed, 09 Dec 2020 05:36:14 GMT https://community.splunk.com/t5/Splunk-Search/compare-row-by-row-values/m-p/532184#M150337 kirrusk 2020-12-09T05:36:14Z https://community.splunk.com/t5/Splunk-Search/compare-row-by-row-values/m-p/532187#M150338 <P>It's not clear what the goal is.&nbsp; Please provide a sample of the desired output.</P> Mon, 07 Dec 2020 13:29:27 GMT https://community.splunk.com/t5/Splunk-Search/compare-row-by-row-values/m-p/532187#M150338 richgalloway 2020-12-07T13:29:27Z https://community.splunk.com/t5/Splunk-Search/compare-row-by-row-values/m-p/532199#M150343 <P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/213957">@richgalloway</a>&nbsp; updated question</P> Mon, 07 Dec 2020 14:31:21 GMT https://community.splunk.com/t5/Splunk-Search/compare-row-by-row-values/m-p/532199#M150343 kirrusk 2020-12-07T14:31:21Z