
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
I have the same question (0)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));
}