Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) ContactPerson table da...

ContactPerson table data cleanup

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

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.

*This post is locked for comments

All responses (1)

Answers (0)

Blue Wang on at

Like (0)

Report

RE: ContactPerson table data cleanup

Hi DevInspirer,

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