How to remove duplicate data from excel

Help Studio
, ,
1

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

@gokul
@Gokul001
@ppr
@ushu
InvalidRejected.xlsx (423.0 KB)

2

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)

image

Regards
Gokult

3

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

1 Like