Dedupe

Avatar

By Anjali Daga

updated about 1 month ago

De-dupe stands for de-duplication and is defined as optimizing data storage by eliminating duplicate copies of data in your table. 

Dedupe is a powerful tool that learns the best way to find similar rows in your data. You can delete duplicates or merge individual fields from duplicate records together.

Deduplication refers to a method of eliminating a dataset’s redundant data. In a secure data deduplication process, a deduplication assessment tool identifies extra copies of data and deletes them, so a single instance can then be stored.

You can use Deduplication to 

  • Merge duplicate leads in a CRM 
  • Clean up your redundant form submissions 
  • Convert a messy CSV into a stack 


Check out this quick video on how Dedupe works

 


Let's see step by step on how you remove duplicate data in Stackby

  1. Login to your Stackby Account and open your stack. 
  2. Select the table in which you want to perform Dedupe. 
  3. Open the menu by selecting the downward arrow present next to Table Name and Select Dedupe.

  4. Now Choose the table and select column(s) for removing duplications. Once you select the columns, it will automatically create a set of duplicated rows on the right. 

  5. Once you choose a primary record, you will see a green checkmark appear in the header. All other records will appear crossed out.

  6. You can also Right Click & Select a particular column from any of the records, to replace it in the final record in Merge Preview. For Example below, you want Title to be 'YouTuber' instead of 'Marketer' but keep everything else same as the first row, you can just click on that column and automatically that replaces the final record. 

7. Click on merge rows. You can execute this merging process over as many records as you want.

          
Voila! Your duplicate records will now be merged in your table. 

Did this answer your question?