Deduplication in Customer Insights

(0) Share

Report

Posted on by Anand Kumar M

122

Hi everyone,

2 questions in duplicate record identification

1) What happens when the column used for identifying duplicates has empty values. Will those records not considered for Duplication or all records be considered as duplicates?

2) When we define a merge preference based on a numeric filed with Most recent option, how does it finds most recent is it based on the highest number in that column?

Can anyone explain these.

Thanks in advance.

I have the same question (0)

All responses (1)

Answers (0)

Scott Stabbert on at

Like (1)

Report
Copy link

Link copied!

Hi Anand,

1. Nulls are not considered a matching value in rules.

2. Correct. When using 'Most recent, or Least recent, you specify a column that has a numeric value. We rank the values, so a numeric will work as well as a Date or DateTime.

Hope that helps!

Scott

Was this reply helpful? Yes No