Skip to main content



No record found.

Microsoft Dynamics AX forum

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!


André Arnaud de Calavon Profile Picture

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

Martin Dráb Profile Picture

Martin Dráb 224,741 Super User

nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans