Merge Recipients and delete orphanded | Community
Skip to main content
Y
yetanother_andrey
Level 3
June 18, 2018
Solved

Merge Recipients and delete orphanded

  • June 18, 2018
  • 2 replies
  • 2891 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by atifm22572383

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-activities/update-data.html?lang=en#record-identification

 

Thanks

Atif

2 replies

J
jc49227835
Level 2
November 15, 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

DimitrisChatzos
DimitrisChatzos
Level 2
February 10, 2021
Does anyone knows how the Update and merge collections works? I have the same issue. Thanks
A
Adobe Employee
atifm22572383Adobe EmployeeAccepted solution
Adobe Employee
February 18, 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-activities/update-data.html?lang=en#record-identification

 

Thanks

Atif

Terms & ConditionsAccessibility statement

Loading footer...