Changing Duplicate Column names

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