Deduplication - keep the records with the smallest value doesn't work | Community
Skip to main content
szymons55769873
szymons55769873
Level 2
February 19, 2020
Solved

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

  • February 19, 2020
  • 1 reply
  • 2515 views

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?

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 Milan_Vucetic

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

 

1 reply

Milan_Vucetic
Milan_VuceticAccepted solution
Level 9
February 19, 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

 

    Terms & ConditionsAccessibility statement

    Loading footer...