I’m attempting to link person records across multiple sources by assigning a LINK_ID to a group of records that satisfy matching rules.
These rules run from most stringent (First/Middle/Last/ Gender/DOB - exact string match) to less stringent e.g. not including gender in the match, fuzz match etc).
When record A = B match on a match rule (all demographics), they get a LINK_ID (e.g 1000000) and MATCH_RULE = indicating it matched on all demogs.
Under the next matching rule, record C matches records A and B (all demographics EXCEPT middle name). Want record C to inherit the LINK_ID from A and B but indicate that it matched on a different match rule that A and B.
It’s the inheritance of the LINK_ID I’m having the most difficulty with. I’m using a multi-row formula, but it’s not evaluating as being true when comparing records between rows.
Perhaps multi-row formula not the best? Perhaps there’s an easier way?
Any ideas?
