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.Collections.ObjectModel System.Runtime.Serialization System.Activities.DynamicUpdate System.Runtime.InteropServices System.Reflection System.ComponentModel System.Xml.Serialization UiPath.CSV UiPath.CSV.Activities BalaReva.EasyExcel.Sheets BalaReva.EasyExcel.Base 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 System.Runtime.Serialization System.Memory UiPath.System.Activities.Design System.ValueTuple UiPath.Cryptography UiPath.Excel UiPath.GSuite.Activities.Design UiPath.OCR.Activities.Design UiPath.UIAutomationCore Microsoft.Bcl.AsyncInterfaces System.ServiceModel System.ComponentModel.Composition System.Collections.Immutable UiPath.Excel.Activities BalaReva.EasyExcel True True False False [dt_Consolidated] [( From part In dt_Driver Group Join trans In dt_Track On trans("UIDb").ToString Equals part("UIDa").ToString.Replace("'","") Into grp = Group From g In grp.DefaultIfEmpty Let UID = g("UIDb") Let Name = part("Name").ToString Let Car = part("Car").ToString Let Track = If(IsNothing(g), "#N/A",g("Track")) Let Country = If(IsNothing(g), "#N/A",g("Country")) Let Remarks = If(IsNothing(g), "#N/A", "WINNER") Select dt_Consolidated.Rows.Add(UID,Name,Car,Track,Country,Remarks) ).CopyToDatatable] False False False False [dt_Consolidated] [( From part In dt_Driver Group Join trans In dt_Track On part("UIDa").ToString Equals trans("UIDb").ToString Into grp = Group From g In grp.DefaultIfEmpty Select dt_Consolidated.Rows.Add({If(IsNothing(g), "#N/A",g("UIDb")),part("Name"),part("Car"),If(IsNothing(g), "#N/A",g("Track")),If(IsNothing(g), "#N/A",g("Country")),If(IsNothing(g), "#N/A", "WINNER")}) ).CopyToDatatable] False False True False False