https://community.splunk.com/t5/Splunk-Search/How-can-I-remove-duplicate-from-multiple-columns-at-once/m-p/621429#M215996 <P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/232122">@marceldera</a>&nbsp;</P><P>Kindly share your solution with other Splunkers and accept that solution to build community.</P><P><STRONG>Happy Splunking</STRONG></P><P>KV</P> Sat, 19 Nov 2022 05:45:28 GMT kamlesh_vaghela 2022-11-19T05:45:28Z https://community.splunk.com/t5/Splunk-Search/How-can-I-remove-duplicate-from-multiple-columns-at-once/m-p/621408#M215988 <P>Paranumber&nbsp;&nbsp;&nbsp; Name</P> <P>95929&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Magnolia Jones Sr.</P> <P>35716&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Leslie Streich</P> <P>99265&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Magnolia Jones Sr.</P> <P>152743&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Kacey Cartwright</P> <P>99265&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Terence Deckow</P> <P>95929&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Magnolia Jones Sr.</P> <P>131568&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dr. Ubaldo O'Kon</P> <P>95929&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Miss Maegan Adams</P> <P>95929&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Magnolia Jones Sr.</P> <P>110231&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Charley Casper</P> <P>How can i remove duplicates only where the two columns natch.&nbsp; for example,&nbsp; 95929&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Magnolia Jones Sr. I want to remove duplicate of the entire row not by columns but by columns.&nbsp;&nbsp;</P> Fri, 18 Nov 2022 19:41:09 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-remove-duplicate-from-multiple-columns-at-once/m-p/621408#M215988 marceldera 2022-11-18T19:41:09Z https://community.splunk.com/t5/Splunk-Search/How-can-I-remove-duplicate-from-multiple-columns-at-once/m-p/621410#M215989 <P>I figured it out</P> Fri, 18 Nov 2022 19:47:07 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-remove-duplicate-from-multiple-columns-at-once/m-p/621410#M215989 marceldera 2022-11-18T19:47:07Z https://community.splunk.com/t5/Splunk-Search/How-can-I-remove-duplicate-from-multiple-columns-at-once/m-p/621429#M215996 <P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/232122">@marceldera</a>&nbsp;</P><P>Kindly share your solution with other Splunkers and accept that solution to build community.</P><P><STRONG>Happy Splunking</STRONG></P><P>KV</P> Sat, 19 Nov 2022 05:45:28 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-remove-duplicate-from-multiple-columns-at-once/m-p/621429#M215996 kamlesh_vaghela 2022-11-19T05:45:28Z https://community.splunk.com/t5/Splunk-Search/How-can-I-remove-duplicate-from-multiple-columns-at-once/m-p/621441#M216003 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/232122">@marceldera</a>,</P><P>I don't know your solution, but it should be dedup for both your fields:</P><LI-CODE lang="markup">&lt;your_search&gt; | dedup Paranumber Name | sort Paranumber Name | table Paranumber Name</LI-CODE><P>Ciao.</P><P>Giuseppe</P> Sat, 19 Nov 2022 10:18:24 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-remove-duplicate-from-multiple-columns-at-once/m-p/621441#M216003 gcusello 2022-11-19T10:18:24Z