web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Deduplication in Custo...

Customer experience | Sales, Customer Insights,...

Unanswered

Deduplication in Customer Insights

(0) Share

Report

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 Img

All responses (1)

Answers Img

Answers (0)

Scott Stabbert Microsoft Employee 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

Join the conversation

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1

ManoVerse 214 Super User 2026 Season 1

#2

CU11031447-0 100

#3

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans