Choose Language Hide Translation Bar
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