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
Yes - that's what you do.
Should work fine, although I have a feeling that there's something that can happen in the merge that makes a later one fail sometimes. (apart from accidentally putting them the wrong way around, of course).
Ken