The virtual world of computers allows us to store junk in an invisible environment. Most of us would be classified as “hoarders” if we could see what is in our both personal and business computers. Since we all live on the go, we “save” because it is easy and tidy. It’s like having your cake and eating it too.
How Virtual Hoarding Starts
It is a busy day at work and a customer calls up to place an order, but your new employee can’t find his customer number, so he creates another profile with some new information on it.
Great, now your system thinks there are two John Smiths. So you begin to look at your customer/client list and there are more duplicates made by that new employee… and clones!
Clones are more of a system error or misinterpretation. With so many different systems communicating, it is very much like foreigners speaking in English to each other.
The basic language is there, but the information is processed differently. This can result in errors, with pieces of information and misspellings that your system doesn’t recognize and automatically creates another profile.
We’ve all done it at one time or another. We decide that it is time to purge (cleanout) and merge (organize) our computer, so we begin to purge (delete) items that are duplicates and merge them into virtual boxes stored nicely in our virtual storage closet.
At first, we are very careful, but there are so many of them, so we begin to highlight and purge blocks of items…then, inadvertently we deleted an extremely important master list, which of course had not duplicated itself in any form, erroneous or not.
Oh no, you need to get it back… but unfortunately, it’s gone forever.
The Perfect Solution
Data Ladder’s DataMatch has this built right in as one of its master tools. DataMatch will merge the above graphic to look like this:
As you can see, DataMatch has merged the fields perfectly into one profile. The added bonus is that DataMatch will never delete information from the original source files. It is like having your cake and eating it!
All information is stored temporarily in your system memory; so you can test various merge and purge settings without worry of deleting important data. DataMatch also offers several output options which includes:
- Creating duplicate records into a separate file
- Different size “field” and list options
- Merged mailing lists