How can I delete duplicate records? | Community
Skip to main content
Level 2
March 27, 2020
Solved

How can I delete duplicate records?

  • March 27, 2020
  • 1 reply
  • 4400 views

I have a table with several duplicate records. How do I leave only the most recent record?

 

I use Adobe Campaign Standard.

 

Thanks

 

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 Craig_Thonis

Hi Fernanda,

 

So to remove duplicates, I'd recommend a workflow with a query activity leading into a dedupe activity that splits the duplicate records into a compliment.  From there you can have that outbound transition lead into an update data activity.  It is within this activity that you can choose to delete these records.  Please see the documentation below:

 

https://docs.adobe.com/content/help/en/campaign-standard/using/managing-processes-and-data/data-management-activities/update-data.html

 

Of course when talking the deletion of data, I'd recommend doing some test runs in your Stage environment, then doing a test run in Production just on a single record before doing any mass delete.

 

Regards,

 

Craig

1 reply

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe EmployeeAccepted solution
Adobe Employee
March 31, 2020

Hi Fernanda,

 

So to remove duplicates, I'd recommend a workflow with a query activity leading into a dedupe activity that splits the duplicate records into a compliment.  From there you can have that outbound transition lead into an update data activity.  It is within this activity that you can choose to delete these records.  Please see the documentation below:

 

https://docs.adobe.com/content/help/en/campaign-standard/using/managing-processes-and-data/data-management-activities/update-data.html

 

Of course when talking the deletion of data, I'd recommend doing some test runs in your Stage environment, then doing a test run in Production just on a single record before doing any mass delete.

 

Regards,

 

Craig