Merge Recipients and delete orphanded

[yetanother_andrey]

Here is the case with AC Classic 6.1:

I have several custom fields for nms:recipient, and all of them are controlled by external DB. E.g. AC receives CSV file from external system and creates nms:recipient records from this file.

At the same time, landing page hosted on AC also creates nms:recipient records.

Because of this I have several (usually 2) nms:recipient records with same email, but one of them are not controlled by external DB (doesn't have values in custom fields).

What I want is to somehow tell AC to:

1. Find all nms:recipient records with same email

2. Merge them into ones where record with custom field (e.g. @externalSystem is not empty) is master record and all broadLogs should be linked to that record

3. Delete all orphaned records without @externalSystem field.

I know there is an 'Update and merge collections' action in Update Data activity, but I can't understand how exactly it should be configured. Will appreciate any advice.

Thx

[jc49227835]

Hey andreyt99885240​

Were you able to find an answer to your problem, I a running across a similar scenario, and would appreciate any help

Thank you

[DimitrisChatzos]

Does anyone knows how the Update and merge collections works? I have the same issue. Thanks

[atifm22572383 · Accepted solution]

Hi,

Can you please check this article from Experience league. This explains the process of merging records. Hopefully this will help you.

https://experienceleague.adobe.com/docs/campaign-classic/using/automating-with-workflows/targeting-a...

Thanks

Atif