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.IO.Compression System.Xml.Serialization UiPath.Excel UiPath.CV Microsoft.VisualBasic.CompilerServices System.Activities Microsoft.VisualBasic mscorlib System.Data System System.Drawing System.Core System.Xml System.Xml.Linq PresentationFramework WindowsBase PresentationCore System.Xaml System.ComponentModel.Composition System.ServiceModel System.Data.DataSetExtensions UiPath.System.Activities UiPath.UiAutomation.Activities System.ValueTuple UiPath.Excel.Activities UiPath.CV True False False True [UniqueParcelId] [ExtractDataTable.DefaultView.ToTable(True,"Parcel ID")] True True True ["Parcel ID"] [row("Parcel ID")] ["SaleDate"] [""] False False [newdate] [DateDt.AsEnumerable().Max(Function (drRows) DateTime.Parse(drRows.Item("SaleDate").ToString)).ToString] False False True True True False False True False False False False False False [DT] [(From p In DT.AsEnumerable() Group By x= New With { Key.a =p.Item("Parcel ID")} Into Grp = Group Select dt.LoadDataRow (New Object() {grp(0)(0), grp(0)(1),grp(0)(2),Grp.AsEnumerable.Max(Function (r) if(String.IsNullOrEmpty(r("SaleDate").toString) Or String.IsNullOrWhiteSpace(r("SaleDate").toString),Nothing,Cdate(r("SaleDate")))),grp(0)(4),grp(0)(5),grp(0)(6),grp(0)(7),grp(0)(8),grp(0)(9),grp(0)(10),grp(0)(11)},False)).CopyToDataTable] True