PaulPeterson1
5 years agoQrew Assistant Captain
Remove Duplicate Records
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
------------------------------
------------------------------
Paul Peterson
------------------------------