https://community.splunk.com/t5/Splunk-Search/How-to-compare-5-different-fields-and-get-the-count-of-their/m-p/550339#M156170 <P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/227232">@aaa2324</a>&nbsp;</P><P>try this.</P><P>&nbsp;</P><LI-CODE lang="markup">YOUR_SEARCh | stats count by category code text country org</LI-CODE><P>&nbsp;</P><P>Sample:</P><LI-CODE lang="markup">| makeresults | eval _raw="category code text country org abc 100 Adv US 12 abc 100 Adv US 12 abc 100 Agh Eu 13 abc 100 Agh Eu 13" | multikv forceheader=1 | table category code text country org | stats count by category code text country org</LI-CODE><P>&nbsp;</P> Tue, 04 May 2021 07:16:49 GMT kamlesh_vaghela 2021-05-04T07:16:49Z https://community.splunk.com/t5/Splunk-Search/How-to-compare-5-different-fields-and-get-the-count-of-their/m-p/550338#M156169 <P>Hi Team,</P><P>I would like to compare below 5 different columns and get one more column as a count.</P><P>category code &nbsp;text &nbsp;country &nbsp;org</P><P>abc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100 &nbsp; &nbsp; &nbsp;Adv &nbsp; &nbsp;US &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12</P><P>abc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100 &nbsp; &nbsp; Adv &nbsp; &nbsp;US &nbsp; &nbsp; &nbsp; &nbsp; 12</P><P>abc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100 &nbsp; &nbsp; Agh &nbsp; &nbsp;Eu &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13</P><P>abc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100 &nbsp; &nbsp; Agh &nbsp; &nbsp;Eu &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13</P><P>Column count should have have the number of times of occurrence of the below, say first 2 entries are occurring 2 time so it should display the output as</P><P>category code &nbsp;text &nbsp;country &nbsp;org &nbsp; Count</P><P>abc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100 &nbsp; &nbsp; &nbsp;Adv &nbsp; &nbsp;US &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12 &nbsp; &nbsp; &nbsp; 2</P><P>kindly help with the query to achieve this.</P> Tue, 04 May 2021 07:07:33 GMT https://community.splunk.com/t5/Splunk-Search/How-to-compare-5-different-fields-and-get-the-count-of-their/m-p/550338#M156169 aaa2324 2021-05-04T07:07:33Z https://community.splunk.com/t5/Splunk-Search/How-to-compare-5-different-fields-and-get-the-count-of-their/m-p/550339#M156170 <P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/227232">@aaa2324</a>&nbsp;</P><P>try this.</P><P>&nbsp;</P><LI-CODE lang="markup">YOUR_SEARCh | stats count by category code text country org</LI-CODE><P>&nbsp;</P><P>Sample:</P><LI-CODE lang="markup">| makeresults | eval _raw="category code text country org abc 100 Adv US 12 abc 100 Adv US 12 abc 100 Agh Eu 13 abc 100 Agh Eu 13" | multikv forceheader=1 | table category code text country org | stats count by category code text country org</LI-CODE><P>&nbsp;</P> Tue, 04 May 2021 07:16:49 GMT https://community.splunk.com/t5/Splunk-Search/How-to-compare-5-different-fields-and-get-the-count-of-their/m-p/550339#M156170 kamlesh_vaghela 2021-05-04T07:16:49Z https://community.splunk.com/t5/Splunk-Search/How-to-compare-5-different-fields-and-get-the-count-of-their/m-p/550399#M156191 <P>Thanks but this is giving me the results as count below.</P><P>abc &nbsp; &nbsp; 100 &nbsp; &nbsp; Adv &nbsp; &nbsp;US &nbsp; 1</P><P>but I want the result to have count as 2 since it is occurring twice.&nbsp;<BR /><BR /></P><P>kindly advise&nbsp;</P> Tue, 04 May 2021 13:23:21 GMT https://community.splunk.com/t5/Splunk-Search/How-to-compare-5-different-fields-and-get-the-count-of-their/m-p/550399#M156191 aaa2324 2021-05-04T13:23:21Z https://community.splunk.com/t5/Splunk-Search/How-to-compare-5-different-fields-and-get-the-count-of-their/m-p/550404#M156194 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2021-05-04 at 7.10.20 PM.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/14033iBDB493BD5CC344AB/image-size/medium?v=v2&amp;px=400" role="button" title="Screenshot 2021-05-04 at 7.10.20 PM.png" alt="Screenshot 2021-05-04 at 7.10.20 PM.png" /></span></P><P>&nbsp;</P><P> It's giving 2 as count. can you please share your sample search ?</P> Tue, 04 May 2021 13:40:54 GMT https://community.splunk.com/t5/Splunk-Search/How-to-compare-5-different-fields-and-get-the-count-of-their/m-p/550404#M156194 kamlesh_vaghela 2021-05-04T13:40:54Z