Database Merging & Purging
Merging & Purging is the process of merging two (or more) sets of data together, usually from different sources and in different formats, standardising, reformatting and removing duplicates. The result being a single cleaned and usable set of data.
In reality it is a lot more complicated and requirers great skill and attention to detail to get right. Merging data together identifying duplicates, reformatting and and moving data from one record to another is a specialist skill and fortunately for our clients one which our data team are experienced in.
Real Life Examples
- Client 1. The client had purchased in a mailing list which had to be deduplicated from their internal customer file. ADMAR identified the duplicates and merged the new data into the clients existing database.
- Client 2. Had to collate data from a wide range of wholesalers across the UK into a single mailing file. Data was supplied in Excel Files, PDF documents, hand written delivery notes and faxed documents. ADMAR captured the data, standardised the information, collated into a single file, removed duplicates and returned a single mailing file to the client.
- Client 3. The client was working in MS Access and regularly took a backup of their file. Unfortunately their marketing team stared working on the backup whilst the rest of the company worked on the main file. The database contained 600,000 records and we had to identify which records had been last used, move the updates to the latest records and return a single file.