Vlookup Linq

Help Activities
, ,
1

table 1
image
table 2
image
Result
image
i need to match table 1 with table 2 if uuid match with guid I need data from table 2 like panelName,Status can anyone help me how to achieve by linq
I am using this two linq but not able to achieve that

“(From d In dtData2.AsEnumerable
Let check = dtData1.AsEnumerable.Where(Function (r) r(0).toString.Trim.Equals(d(0).toString.Trim)).toList
Let c2 = If(check.Count() > 0, check(0)(0), “”)
Let ra = {d(0),d(1),c2}
Select dtResult.Rows.Add(ra)).CopyToDataTable”

“(From a In dt1.AsEnumerable() Join b In dt2.AsEnumerable() On a.Item(“uuid”) Equals b.item(“GUID”) Select dt3.LoadDataRow (new Object() { a.Field(Of Double)(“uuid”),b.Field(Of String)(“PanelName”),b.Field(Of String)(“Status”)},False)).CopyToDataTable”—this is giveing me error like string not cast double

please help me with other solution of correct me if I am wrong somewhere

2

LINQ can be based on a inner join

(From d1 in dt1.AsEnumerable
Join d2 in dt2.AsEnumerable
On d1(“uuid”).toString.Trim() Equals d2(“Guid”).toString.Trim()
Select d2).CopyToDatatable

CopyToDataTable will throw an exception in case of empty result. Here we do handle this defensive by following pattern:

grafik
grafik707×346 46.6 KB

3

Could you please share flow

4

Hello Aleem,
Here I have multiple ways how to do VLOOKUP (including multiple files):

Thanks,
Cristian