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