How to avoid the duplicate column in excel

[vivekktr (vivek)]

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

[AshwinS2 (Ashwin S)]

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

[vivekktr (vivek)]

plz share me a sample xml file

[vivekktr (vivek)]

it Show object reference not set

[vivekktr (vivek)]

plz share me an sample xml file

[AshwinS2 (Ashwin S)]

Hi @vivekktr

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

Thanks
Ashwin S

[vivekktr (vivek)]

[AshwinS2 (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

[vivekktr (vivek)]

Hai am not getting your point
please find below

[vivekktr (vivek)]

duplicate.xls (7.5 KB)

[vivekktr (vivek)]

duplicate.xls (7.5 KB)