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
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));
}
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156