Deduplication - keep the records with the smallest value doesn't work

Avatar

Avatar
Ignite 1
Level 2
szymons55769873
Level 2

Likes

5 likes

Total Posts

22 posts

Correct reply

0 solutions
Top badges earned
Ignite 1
Validate 1
Give Back
Boost 5
Boost 3
View profile

Avatar
Ignite 1
Level 2
szymons55769873
Level 2

Likes

5 likes

Total Posts

22 posts

Correct reply

0 solutions
Top badges earned
Ignite 1
Validate 1
Give Back
Boost 5
Boost 3
View profile
szymons55769873
Level 2

19-02-2020

Hi

 

I'm using a deduplication activity and choosing 2 fields to base the deduplication on, in the next step, I choose a field that differentiate the records, which a numeric value. When I pick "Using an expression" method and choose the field and the option to Keep the records with the smallest/largest value I doesn't work - it picks the last (if largest is chosen) or first (if smallest is chosen) record from the duplicates from the previous transition, totally disregarding the value in the field picked. 

 

Any ideas why would this happen?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

167 likes

Total Posts

386 posts

Correct reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

167 likes

Total Posts

386 posts

Correct reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile
Milan_Vucetic
MVP

19-02-2020

Hi @szymons55769873 

 

did you ensure that mentioned numerical value is not empty for some records?

Please, check this example for better understanding how deduplication works: https://helpx.adobe.com/campaign/classic/how-to/handle-doubles-in-acv6.html

 

Regards,

Milan

 

Answers (0)