LINQ query to find data present in another excel if data matches with corresponding value

@sandyk
the join type is currently not derivable from the description as it is not specifying on how to handle non matching city codes from dt1 in dt2.

The join datatable would help to do it with an out of the box uipath activity.

Doing it with LINQ could look like this:

(From d1 In dt1.AsEnumerable
Join d2 In dt2.AsEnumerable
On d1("City_Code").toString.Trim Equals d2("City_Code").toString.Trim
Select d2).CopyToDataTable 

Find starter help here:
Match_1Col_ResultKeyColMatchVal.xaml (8.6 KB)