Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Merge Recipients and delete orphanded

yetanother_andrey
Level 3
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
atifm22572383
Correct answer by
Employee
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
jc49227835
Level 2
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

DimitrisChatzos
Level 1
Level 1
Does anyone knows how the Update and merge collections works? I have the same issue. Thanks
atifm22572383
Correct answer by
Employee
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