Linq to compare 2 excel sheets and select particular column to create 3rd sheet

[ppr (Peter Preuss)]

@Boopathi
Give a try on
(From d1 In dt1.AsEnumerable
Join d2 In dt2.AsEnumerable
On d1(“Name”).toString.trim Equals d2(“Name”).toString.trim
Select d1).CopyToDatatable

d1 = sheet1
d2 = sheet2
use the statement within an assign activity and assign it to e.g dt3 (DataType: DataTable)
Kindly Note: CopyToDataTable throws an exception if returned result is empty (does mean: has no rows)