Merge Recipients and delete orphanded

Avatar

Avatar

yetanother_andrey

Avatar

yetanother_andrey

yetanother_andrey

18-06-2018

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar

atifm22572383

Employee

Avatar

atifm22572383

Employee

atifm22572383
Employee

18-02-2021

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

Avatar

Avatar

jc49227835

Avatar

jc49227835

jc49227835

15-11-2018

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