Hello, I have a DB ~15,000 records. I wrote a script to merge and delete records. It compares three data fields for duplications and combines the duplicate records. It also will merge data from two other fields if the fields are not empty. I tested m...
Hello, I'm trying to merge records in my table when 3 criteria match. I've been able to identify which records are duplicates, but I am having trouble merging them. Logically I believe my code should do what I want it do, I am not super familiar with...
Hello, I found my own answer.I sort the database first by name, then iterate through until the value changes. This way I'm not running a O^2 search on a 15k record database. This is not my full code as it is not all relevant to this question: var tab...
Hello, Thank you for the reply. I cannot use dedupe as there are hundreds of duplicates in my table. I had an initial table and then received several other tables with most of the same information but some records had additional information. So I am ...
