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





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)

Answers (0)