V-lookup Challenge

[ppr (Peter Preuss)]

@dasharath.nd
Give a try on Following

Use an assign Activity
Left side: dtResult - datatype of Datatable

Use an assign Activity
Left Side : dtResult
Right side Respekt the Line breaks)

(From d in dt2.asenumerable
Join dl In dt1.asenumerable
On d(0).toString.trim Equals dl(0).toString.trim
Let ra= dl.Itemarray
Select dtResult.Rows.Add(ra)).CopyToDataTable

In dtResult you will get the lookup result

Find starter help here
DataTable_Join_1Col.xaml (10.3 KB)