How to remove duplicate data from excel

Hi All,

I need to remove the duplicate data from an excel based on the column “MRN”,
can some one help me to do this?Please refer the excel

InvalidRejected.xlsx (423.0 KB)

Hi @HeartCatcher

Try with this expression

(From p in DT.Select() where( From q in DT.Select() where q("MRN").Equals(p("MRN")) Select q).ToArray.Count=1 Select p).ToArray.CopyToDataTable()

Check out the XAML file

RemoveDuplicateRows.xaml (9.4 KB)



Hello, @HeartCatcher - Please check below link. It has detailed description of the steps involved

1 Like