Excel compare 2 Column

Hi @soundarya.a

Make dictionary of the 2nd Data Table with key as the first column and value can be anything

Use ContainsKey method to check if the Name is present or Not

image

Refer the xaml file

LINQ_DT_ComparisonWithDictApproach.xaml (11.6 KB)

It is based on the approach by @ppr