Comparing the 2 values

Help Studio
, ,
6

we assume Read, Sheet are datatables, Query should return an Array of Datarows with the matching datarow pairs. Amount, Due Amount are column names

(From t1 In Read.AsEnumerable
From t2 In Sheet.AsEnumerable
Where t1(“Amount”).toString.Trim.Equals(t2(“Due Amount”).toString.Trim)
Select x = New DataRow() {t1, t2}).toList

will return a List(Of DataRow()) - list of datarow array

[HowTo] LINQ (VB.Net) Learning Catalogue - Help / Something Else - UiPath Community Forum

1 Like