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 UiPath.Excel System.Xml.Serialization System.Activities Microsoft.VisualBasic mscorlib System.Data System.Data.DataSetExtensions System System.Drawing System.Core System.Xml System.Xml.Linq PresentationFramework WindowsBase PresentationCore System.Xaml UiPath.System.Activities UiPath.UiAutomation.Activities UiPath.Excel UiPath.Excel.Activities T True True [dtResult] [(From d In dtData.AsEnumerable Group d By k=d(0).toString.Trim Into grp=Group Let xyzRes = XYZSet.Select(Function (x) grp.AsEnumerable.Count(Function (r) r("Column 2").toString.Trim.Equals(x))).Cast(Of Object).toArray Let netRes = XYZSet.Select(Function (x) grp.AsEnumerable.Count(Function (r) r("Column 2").toString.Trim.Equals(x) And Not r("Column 3").toString.Equals(NETerm))).Cast(Of Object).toArray Let ra = New Object(){k}.Concat(xyzRes).Concat(netRes).toArray Select dtResult.Rows.Add(ra)).CopyToDataTable]