Empty and excel are not empty

data table excel are duplicate record and excel is empty both condition one program are output then are not error
1)excel are duplicate record
2)excel are empty
both condition are successfully run in one program how to that solution

datatable activity use ho

Hi @nikhil.patil

How about this expression Duplicate Record?

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

Regards
Gokul