Expand my Community achievements bar.

SOLVED

Merge Recipients and delete orphanded

Avatar

Level 3

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

1 Accepted Solution

Avatar

Correct answer by
Employee

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

View solution in original post

3 Replies

Avatar

Level 2

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

Avatar

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

Avatar

Correct answer by
Employee

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