Forum Discussion

nerdyplayer's avatar
nerdyplayer
Helper I
1 year ago
Solved

remove duplicates per year

I have a data set where that i want to filter out duplicate entries per year. Tried looking on here and doing group by, got an error during the process.  Table audit test ICN    Year V1234 2019 V...
Need Help
  • quantumudit's avatar
    quantumudit
    1 year ago

    Hey nerdyplayer 

    It is actually much simpler than you might have anticipated.

     

    If I have understood your requirement correctly, all you need to do is select both columns, namely "ICN" and "Year," then right-click and choose "Remove Duplicates." You can select multiple columns by holding down the CTRL key.

     

    Here is the sample GIF for your referece:

     

    Best Regards,
    Udit

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudo 👍

    🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
    ✨ Visit My Linktree: LinkTree

    Proud to be a Super User

     

     

quantumudit's avatar
quantumudit
Super User
1 year ago

Hey nerdyplayer 

It is actually much simpler than you might have anticipated.

 

If I have understood your requirement correctly, all you need to do is select both columns, namely "ICN" and "Year," then right-click and choose "Remove Duplicates." You can select multiple columns by holding down the CTRL key.

 

Here is the sample GIF for your referece:

 

Best Regards,
Udit

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍

🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree

Proud to be a Super User