Subscribe Bookmark RSS Feed
gail_massari

Community Manager

Joined:

Feb 27, 2013

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.)

(view in My Videos)

Article Labels
Article Tags
  • Find more articles tagged with:
Contributors