How to find duplicate data in table ?

(0) Share

Report

Posted on by Khaled Ahmed

2,467

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.

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

Mea_ 60,278 on at

Like (1)

Report
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)); }