Hi, I Have this scenario. I Have multiple excel files with chances to have a duplicate column in header name I want to find if the excel file has a duplicate column name and then rename it with a running number, example in the column name I have column name, address, address I want to rename it t…

@rangga.waskita Okay, Check below post for your reference [image] How to change the name of a column in excel, if the columns already exists? Help Hi everyone! I have multiple excel files and I’m having an issue processing them. Some of the files have columns with the s…

@rangga.waskita Inside of renaming the header names You can do without that as below Use Read Range and remove the Add headers option Now you can use your automation using the index of the columns like dt(0)(1) Which is datable 0-> 1st row and (1) will be the column Hope this may help you Th…

Hi @Srini84 , Because the excel file that I working is random, how I can find the duplicate value if I don’t know which column has a duplicate value? for example, the address column could be the first column or it can be the second column Thanks

Rename Duplicate Column in Data Table

Help Studio

Srini84 (Srinivas Kadamati) August 10, 2021, 4:24pm 4

@rangga.waskita

Okay, Check below post for your reference

Hope this may help you

Thanks

Rename duplicate column names

Topic		Replies	Views
Rename Duplicate Column in an excel Forum excel , question	9	2771	July 1, 2022
How to rename if Same column name in excel Studio studio , question , find_references	19	2155	December 17, 2022
How to rename columns in excel having same column names? Studio studio , question , activities_panel	4	1966	September 26, 2022
How to change the name of a column in excel, if the columns already exists? Help excel , activities , question	9	4956	February 12, 2020
How to excel file contains Multiple columns with same name Activities excel	4	3163	April 25, 2022

Rename Duplicate Column in Data Table

Related topics