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.ComponentModel System.Runtime.Serialization System.Xml.Serialization System.Reflection System.Runtime.InteropServices System.Runtime.CompilerServices 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.Runtime.Serialization System.Collections.Immutable System.Linq.Async System.Linq.Async.Queryable System.ServiceModel Microsoft.Bcl.AsyncInterfaces System.ValueTuple System.ComponentModel.Composition System.Memory NPOI System.Memory.Data UiPath.UIAutomationCore UiPath.OCR.Activities.Design OfficeDevPnP.Core UiPathTeam.SharePoint System.Runtime.WindowsRuntime True [arrBlockColInfo] [arrBlockIDX.Select(Function (x) Tuple.Create(x,"")).toArray] [arrColInfo] [dtData.Rows(1).ItemArray.Select(Function (x,i) Tuple.Create(i,x.ToString.ToUpper.Trim)).Where(Function (t) Not arrBlockIDX.Contains(t.Item1)).ToArray] [arrDupColInfo] [(From t In arrColInfo Group t By k=t.Item2 Into grp=Group Where grp.Count > 1 Select x = grp.First()).toArray] [arrUniqueColInfo] [(From t In arrColInfo Group t By k=t.Item2 Into grp=Group Where grp.Count = 1 Select x = grp.First()).toArray] [arrUniqueColSet] [(From t In arrUniqueColInfo.Concat(arrBlockColInfo) Order By t.Item1 Select n = dtData.Columns(t.Item1).ColumnName).toArray] [arrDupColSet] [(From t In arrDupColInfo.Concat(arrBlockColInfo) Order By t.Item1 Select n = dtData.Columns(t.Item1).ColumnName).toArray] [dtUnique] [dtData.DefaultView.ToTable(False,arrUniqueColSet)] [dtDuplicated] [dtData.DefaultView.ToTable(False,arrDupColSet)]