Paranumber Name
95929 Magnolia Jones Sr.
35716 Leslie Streich
99265 Magnolia Jones Sr.
152743 Kacey Cartwright
99265 Terence Deckow
95929 Magnolia Jones Sr.
131568 Dr. Ubaldo O'Kon
95929 Miss Maegan Adams
95929 Magnolia Jones Sr.
110231 Charley Casper
How can i remove duplicates only where the two columns natch. for example, 95929 Magnolia Jones Sr. I want to remove duplicate of the entire row not by columns but by columns.
I figured it out
Hi @marceldera,
I don't know your solution, but it should be dedup for both your fields:
<your_search>
| dedup Paranumber Name
| sort Paranumber Name
| table Paranumber Name
Ciao.
Giuseppe
Kindly share your solution with other Splunkers and accept that solution to build community.
Happy Splunking
KV