Hi Team, A bot of mine downloads a csv file from a portal and copies it a Google sheet. Today, it happened to see that there occured 2 columns with the same name . Hence, bot threw error saying that column already exists in the data table. So, in future, if any columns appear more than one time, I …

I came up with a better way. Read CSV without headers (so column names are in row 0) Loop through row 0 values. If value appears more than once, delete column Loop through columns and rename from row 0 Remove row 0 Main.xaml (22.3 KB)

Delete duplicate columns in a CSV

Help Activities

Yoichi (Yoichi) January 30, 2024, 12:21am 4

Hi,

The following post and sample will help you. (This renames either of duplicated column name. )

Regards,

Topic		Replies	Views
How to delete the columns in CSV file Studio studio , question , activities_panel	7	1653	July 26, 2022
How to Remove Duplicate columns in csv and overwrite existing one Studio studio , question , activities_panel	1	898	December 20, 2021
Remove Duplicate Column From csv or List of string Activities excel , csv , activities	0	1190	February 5, 2021
Need to delete Duplicate columns Help	12	4422	February 14, 2020
I have csv data but i want to delete colomn1, colomn2.... in header file Activities excel , activities , question	7	545	June 13, 2023

Most Active Users - Yesterday
Yoichi
ashokkarale
Shreya_Gandhi
Anil_G
mjoseph74
Vinit_Mhatre
Ankit_Kumar2
Youri98
dutta.marina
adi.mehare
More details...

Delete duplicate columns in a CSV

Related topics