Skip to main content
Question

Remove Duplicate Records

  • December 2, 2020
  • 0 replies
  • 89 views

This question is a tribute to the law of unintended consequences.  There is a webhook in table 1 that will create a new record in a table 2 in a different app when a new record is added to the  to table 1 and a checkbox is checked.  That had been working ok for the new records that were initially imported with the checkbox checked.  However, the source data for the import is not always accurate and the checkbox is not checked.   The webhook was modified to fire when a record was added or modified and there a check was added to the checkbox.  That seemed to make sense, but it created duplicate records every day when the data was uploaded (I should mention, table 1 currently has a manual update every morning that includes all previous records plus any new records that were added the previous day).  After two weeks, there are over 125k duplicate records.  Is there way to remove the duplicate records without resorting to brute force manual deletion of the duplicates?

------------------------------
Paul Peterson
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • December 2, 2020
125,000 duplicates OMG!

Can you run a summary report on whatever makes these unique and export to excel.  Delete all the records and then import the summary report?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------