Hi,How can i change duplicate column names from excel sheet.
1 Like
Hi @Mayyur
I hope this post will give you an idea:
You can then use this in an Assign activity to change the names:
DataTable.Columns(Column Index).ColumnName= 'ABC'
or
DataTable.Columns("columnName").ColumnName= 'ABC'
1 Like