Hi all
I'm working with a database that has been created from extracts from a number of sources. This has resulted in multiple records (ie, more than just duplicate) for some individuals. So my question is, how do I merge these multiple entries into one?
Do I schedule several merge lines which all have the same Keep constituent but different delete constituents? Will this work in the same merge process or would I have to do it over several cycles?
How have you guys solved this problem?
Blair
Hi Blair,
You can’t schedule multiple merges into the same Keep constituent in the same pass of the merge utility. So if you have constituents 1, 2, 3, and 4, and your goal is to end up with just constituent 1, the simplest strategy is, during this cycle of merging:
DELETE constituent 2 > KEEP constituent 1
DELETE constituent 4 > KEEP constituent 3
In the next merge cycle:
DELETE constituent 3 > KEEP constituent 1
This can be replicated for as many pairs of merge constituents as necessary until you get down to the one you want.
Unknown said: You can’t schedule multiple merges into the same Keep constituent in the same pass of the merge utility
I may be misunderstanding, but I do this regularly:
DELETE constituent 4 > KEEP constituent 1
E.g. I merged eleven delete constituents into one keep const on 7/16 in the same run of AP_IDENTIFY_DUPLICATES.
AFAIK the one you can't do is:
DELETE constituent 4 > KEEP constituent 2