Empty and excel are not empty

Learning & Development Programs Automation Starter
1

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

2

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