Hey,
I am working on table which include duplicates for address field. Earlier I had to define one record from the duplicate set and assign there value "keep" and for the rest of duplicated records I had to assign value "dup". In the end of the day, duplicated records need to be found in the repository with attribute Merged_Id which indicate ID of the "keep" record from the duplicated set.
I would like to ask how to do it in the smartest way, considering conditions that if Merged_ID has missing value and address is duplicated in the certain group (left side of the pic), duplicated records 'dup' will have Merged_ID the same as "keep" record (right side of the pic).
Thank you!