How to avoid the duplicate column in excel

Hi
How to avoid the duplicate column in excel without deleting that column name

Hi @vivekktr

check this

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

Thanks
Ashwin S

plz share me a sample xml file

it Show object reference not set

plz share me an sample xml file

Hi @vivekktr

Have u assign the column name along with assign as new dt

Thanks
Ashwin S

Hi @vivekktr
use assign activity and create a new datatable as newdt=linq query I have given
Use output datatable activity
Use message box of strvar

Thanks
Ashwin.S

Hai am not getting your point
please find below

duplicate.xls (7.5 KB)

duplicate.xls (7.5 KB)