Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
gail_massari
Community Manager Community Manager

Is it possible to find and get rid of duplicate rows easily?

Olivia Lippincott shares a tip from Byron Wingerd for an easy way to find and get rid of duplicate rows. Join the table to itself (Tables>Join), match all columns, drop multiples for the Main and With Tables, and then save the joined table with a new name.  (Saving with a new name is most always better than renaming or changing in place because it allows you to examine the changes and assure they reflect what you really wanted to do.)

Article Tags
Contributors