System.Activities System.Activities.Statements System.Activities.Expressions System.Activities.Validation System.Activities.XamlIntegration Microsoft.VisualBasic Microsoft.VisualBasic.Activities System System.Collections System.Collections.Generic System.Data System.Diagnostics System.Drawing System.IO System.Linq System.Net.Mail System.Xml System.Xml.Linq UiPath.Core UiPath.Core.Activities System.Windows.Markup System.Reflection System.Runtime.InteropServices System.Collections.ObjectModel System.Activities.DynamicUpdate System.ComponentModel System.Runtime.Serialization System.Xml.Serialization UiPath.Excel UiPath.Excel.Activities UiPath.UIAutomationNext.Enums System.Security UiPath.UIAutomationNext.Activities UiPath.Platform.ObjectLibrary UiPath.Shared.Activities Microsoft.VisualBasic.CompilerServices UiPath.UIAutomationNext.Models.ExtractData UiPath.UIAutomationNext.Contracts System.Activities Microsoft.VisualBasic mscorlib System.Data System System.Drawing System.Core System.Xml System.Xml.Linq PresentationFramework WindowsBase PresentationCore System.Xaml UiPath.System.Activities UiPath.UiAutomation.Activities System.Data.DataSetExtensions System.Memory System.ServiceModel Microsoft.Bcl.AsyncInterfaces System.ValueTuple System.ComponentModel.Composition UiPath.Excel UiPath.Mail UiPath.OCR.Activities.Design UiPath.UIAutomationCore System.Runtime.Serialization UiPath.Excel.Activities.Design UiPath.Excel.Activities UiPath.System.Activities.Design UiPath.UIAutomationNext UiPath.UIAutomationNext.Activities UiPath.Platform UiPath.Mail.Activities UiPath.OCR.Activities System.Collections.Immutable True [dtOutput] [(From row In dtInput.asenumerable Group row By k = row("Items").tostring Into grp = Group Let sum = grp.sum(Function(x) CDbl(x("No. Of Items").tostring)) Let ra = New Object() {grp(0)("Items"),sum} Select dtOutput.rows.add(ra)).copytodatatable]