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

How can I delete duplicate records?

Avatar

Avatar
Level 1
fernandac322631
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
fernandac322631
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
fernandac322631
Level 1

27-03-2020

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

 

I use Adobe Campaign Standard.

 

Thanks

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

167 likes

Total Posts

258 posts

Correct Reply

152 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

167 likes

Total Posts

258 posts

Correct Reply

152 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile
craigthonis
Employee

31-03-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-mana...

 

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

Answers (0)