Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

How to find duplicate data in table ?

Posted on by 2,465

Hi ;

We have more than 400 K items in InventTable , I need to find the duplicate data in filed "InventTable .Name Alias"  by x++ . Can any one help in this case ?

Many Thanks in Advance.

  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,274 on at
    RE: How to find duplicate data in table ?

    You can use something like 

    InventTable inventTable;
    InventTable inventTableDuplicate;
    
    while select inventTableDuplicate
        join inventTable
            where inventTable.NameAlias == inventTableDuplicate.NameAlias
               && inventTable.RecId     != inventTableDuplicate.RecId
    {
        info(strFmt("%1 is a duplicate of %2", inventTableDuplicate.ItemId,  inventTable.ItemId));
    }

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,663 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,741 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans