We have a task of identifying and merging duplicate records into one record, we are having a hard time identifying how to do that in bulk.
There are thousands of records that share the same email but different source ID, we want to merge all records into one keeping the lowest sourceID. any ideas on how to tackle this are greatly appreciated it
In that case, you can update the duplicate sourceIDs with lowest sourceID in broadlog/tracking log tables using the same workflow. It is better not to play around much with the logs. Any way they gets purged depending on your settings.
Sorry for the late reply, we had put this in the back burner for a while, I would not want to play around with the logs if there is a possibilty they get purged. would there be another way? or we are out of luck and should decide if we just want to keep/delete the duplicates even though they have deliveries associated with them?
I know there is a merge action on the list (only processes 2 records at the time) could this not be repurposed to do in tn bulk?