Remove duplicate header from excel

Hi ,

I am exporting one excel file from SAP system which two duplicate columns i.e . Old Value and New Value. I wanted delete Column K and L after that only I can apply filter on Changed by Column.

When I am reading it in read range it is throwing error. Please help.

Hi @Shirish

Are you able to change the column names on the SAP view?

nope

Then maybe try read range and deselect the use first row as headers option. Change the first row values, save the Excel file and try reread it with first row as headers selected

@Shirish

Use Insert/Delete Columns activity to do this.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.