Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
The CONTACTPERSON table has 6 million records and most of them are duplicates. We are planning to migrate data from AX2009 to D365, before migrating this table, we wanted to make sure that duplicates in CONTACTPERSON table are deleted. I tried relating this table with CUSTTABLE, VENDTABLE ,PURCHTABLE ,SALESTABLE ,SMMBUSRELTABLE. But there are only 50,000 records in common. When I tried comparing CONTACTPERSON table with DIRPARTYTABLE, almost 5.9 million records were in common for both these tables based on PartyID column. Can someone help me, how to find and clear these duplicates in CONTACTPERSON table.
Find out why you duplicate data in your table and identify which fields are duplicated.
Walk through these fields and sort them, then delete them from the second duplicate data.
You can refer code: https://shyamkannadasan.blogspot.com/2018/03/how-to-delete-duplicate-records-through.html
Business Applications communities