2,469
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
You can use something like
Share
Report
All responses (
Answers (
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));
}
#1
André Arnaud de Cal...
291,784
Super User 2024 Season 2
#2
Martin Dráb
230,476
Most Valuable Professional
#3
nmaenpaa
101,156
