Here is the scenario:
Matcher_Matched produces some rows. Matcher_SingleMatched is populated, but that set is sub-optimal (e.g., an attribute is null compared to that within the other matched row). I need a way to tailor the single-matched rows so they contain the most valuable rows based on a comparison of the matched rows based on attribute comparison criteria.
So, what is the simplest way to loop through the Matcher_Matched result set in order to pick the desired row from those with the same match_id?
Thanks,
Pete
