Comparing the 2 values

[Rahul_PK (Rahul Kumar)]

HI Guys,
Im comparing 2 values is equal or not .
i used the syntax
From t1 In Read
From t2 In Sheet
Where(t1.Amount = t2.Due Amount)
Select New {t1, t2}
i have attached the error image.
Any suggestions pls

[Sudharsan_Ka]

HI @Rahul_PK

Can you explain your task and can you share the sample input and expected output here? @Rahul_PK

Regards
Sudharsan

[Rahul_PK (Rahul Kumar)]

need to check the data is equal or not. my input is Amount 80 from a excel sheet this input need to validated with another excel sheet and the header is due amount i need to check is amount = due amount

[Sudharsan_Ka]

Can you tell what type of data you need to compare is it a string or datatable

Send sample input and expected output @Rahul_PK

[Rahul_PK (Rahul Kumar)]

Its a data table

[ppr (Peter Preuss)]

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