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

Fetching Duplicate Records Only

Avatar

Avatar
Validate 1
Level 1
shashanks445952
Level 1

Likes

0 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
shashanks445952
Level 1

Likes

0 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
shashanks445952
Level 1

10-11-2020

I've a use case where I have a table with several duplicate records now I want to fetch only the  duplicate users and delete some fields data for those users only where the data was updated 6 months ago .

 

I use Adobe Campaign Classic.

 

Thanks!!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Affirm 5
Level 4
ParthaSarathy
Level 4

Likes

34 likes

Total Posts

61 posts

Correct Reply

26 solutions
Top badges earned
Affirm 5
Establish
Give Back
Boost 5
Boost 3
View profile

Avatar
Affirm 5
Level 4
ParthaSarathy
Level 4

Likes

34 likes

Total Posts

61 posts

Correct Reply

26 solutions
Top badges earned
Affirm 5
Establish
Give Back
Boost 5
Boost 3
View profile
ParthaSarathy
Level 4

11-11-2020

 Hi @shashanks445952 ,

This workflow logic will help you to solve your use case.

Workflow logic.PNG

1) Query: Fetch all records from your table ( @id not equal to 0)

2) Dedupliction: select 'Generate complement' and in 'Edit configuration' select temporary schema and in next step add the expression to identify the duplicates. For example, if it is recipient schema, you can identify your duplicates by @email. So when you run the workflow, duplicates records will come in complement transition.

3) Split: Here you can add your filtering condition to filter last Modified 6 months ago.

4) Update data: Here you can delete or update those records as per your business logics.

 

Regards,

ParthaSarathy S

 

Answers (0)