Need to check Highlighted Columns values exist or not

[shaik.muktharvalli1 (shaik muktharvalli)]

Need to check Highlighted Columns values exist or not in dt1

dt1:
ADD FWIMSIBLK.xlsx (69.5 KB)

dt2:
Huawei_IR21_DB.xlsx (9.5 KB)

Thanks
Shaik

[Anil_G (Anil Gorthi)]

@shaik.muktharvalli1

We can use this to get only the rows where the data is present in dt1…use in assign

requireddatatable = Dt2.AsEnumerable.Where(function(x) dt1.AsEnumerable.Any(function(y) y(0).ToString.Contains(x("E212").ToString) AndAlso y(0).ToString.Contains(x("E214").ToString))).CopyToDataTable

Cheers