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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

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

szymons55769873
Level 2
Level 2

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?

1 Accepted Solution
Milan_Vucetic
Correct answer by
Community Advisor
Community Advisor

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

 

View solution in original post

1 Reply
Milan_Vucetic
Correct answer by
Community Advisor
Community Advisor

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

 

View solution in original post