470,575 Members | 1,649 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,575 developers. It's quick & easy.

Merging a data mess

I've been handed a mess of related data in the form of multiple spead
sheets. Each set of data contains part or parts of the what is needed
in the final database but there is no common usable column that is
usable for selecting data from all sources and no two sets contain all
the rows of any other. By that, I mean that one list will have member
names as (last, first, middle) while another omits the middle name and
a third contains only the full name, including suffix. One is
formatted mixed case, another is all upper case, a third is a mix of
both. Each set contains a subset of names from one master list, but
not necessarily the same names as any other set. The case issue is
simple - a word processor and a quick macro on the .del file solves
that problem in a few minutes but I'm still left with the problem of
reconciling all these disparate sources. The ambiguities (how many
David Smiths can there be in 80k entries?) can be partially resolved
with address matches, etc but will still have to be flagged.

Anybody got a decent plan for attacking a mess like this? Ideally,
the end result will be something like 3 or 4 tables with a common data
column to use for linkages. So far, I've come up with several schemes
but they all appear to invoke cartesian searches and run forever so I
need some expert advice or a pointer to a tutorial source somewhere.

Will Honea
Nov 12 '05 #1
0 1117

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Klatuu | last post: by
3 posts views Thread by Patrick | last post: by
2 posts views Thread by Emmett Power | last post: by
15 posts views Thread by PRadyut | last post: by
3 posts views Thread by Sanjib Biswas | last post: by
7 posts views Thread by Jon Vaughan | last post: by
1 post views Thread by livre | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.